Important Packages

1. follwing package for getting AR invoice related detailes.
arpt_sql_func_util

2. follwing package for getting Gl related descriptionsa and other informations.
gl_flexfields_pkg

e.g. 

SELECT gcc.SEGMENT4||' '||gl_flexfields_pkg.get_description_sql (50354,
                                                      4,
                                                      gcc.SEGMENT4
                                                     ) 
                                                     INTO V_TAX_ACC_CODE_DESC
              FROM gl_code_combinations gcc

3. Follwoing package for getting Po related information like po and grn created person name ,aslo for
some other uses.

po_inq_sv.get_person_name

 
4. Follwoing package for getting invoice status e.g. invoice is approved or cancelled

AP_INVOICES_UTILITY_PKG.get_approval_status(aia.INVOICE_ID,
                                                      aia.INVOICE_AMOUNT,
                                                      aia.PAYMENT_STATUS_FLAG,
                                                      aia.INVOICE_TYPE_LOOKUP_CODE )