[Home] [Help]
4454: TYPE invoice_num_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;
4455: TYPE invoice_type_code_t IS TABLE OF AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
4456: TYPE invoice_amount_t IS TABLE OF AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4457: TYPE vendor_name_t IS TABLE OF AP_SUPPLIERS.vendor_name%TYPE INDEX BY BINARY_INTEGER;
4458: TYPE vendor_site_code_t IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE INDEX BY BINARY_INTEGER;
4459: TYPE org_id_t IS TABLE OF AP_INVOICES_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER;
4460: TYPE set_of_books_id_t IS TABLE OF AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE INDEX BY BINARY_INTEGER;
4461: TYPE process_flag_t IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
4462: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
4849: ' NVL(dr.return_status,''Data Processed'') '||
4850: ' FROM '||l_driver_table||' dr, '||
4851: ' ap_invoices_all ai, '||
4852: ' ap_suppliers av, '||
4853: ' ap_supplier_sites_all avs, '||
4854: ' ap_system_parameters_all aps '||
4855: ' WHERE ai.invoice_id = dr.invoice_id'||
4856: ' AND ai.org_id = aps.org_id'||
4857: ' AND ai.vendor_id = av.vendor_id'||
4938: ' NVL(dr.return_status,''Data Processed'') '||
4939: ' FROM '||l_driver_table||' dr, '||
4940: ' ap_invoices_all ai, '||
4941: ' ap_suppliers av, '||
4942: ' ap_supplier_sites_all avs, '||
4943: ' ap_system_parameters_all aps '||
4944: ' WHERE ai.invoice_id = dr.invoice_id'||
4945: ' AND ai.org_id = aps.org_id'||
4946: ' AND ai.vendor_id = av.vendor_id'||