APPS.JAI_FBT_PROCESS_P dependencies on AP_INVOICES_ALL

Line 633: FROM AP_INVOICES_ALL aia

629: THEN
630: IF pn_source = 'Payables' THEN
631: SELECT aia.exchange_rate
632: INTO ln_exchange_rate
633: FROM AP_INVOICES_ALL aia
634: , Ap_Invoice_Distributions_All aida
635: WHERE aida.invoice_distribution_id = pn_inv_dist_id
636: AND aida.invoice_id = aia.invoice_id;
637: ELSE --pn_source = 'Others'

Line 757: FROM ap_invoices_all aia

753: WHERE aida.invoice_distribution_id = pn_inv_dist_id;
754:
755: SELECT invoice_num
756: INTO x_fbt_repository_type.je_name
757: FROM ap_invoices_all aia
758: , ap_invoice_distributions_all aida
759: WHERE invoice_distribution_id = pn_inv_dist_id
760: AND aia.invoice_id = aida.invoice_id;
761:

Line 1120: ap_invoices_all head

1116: , head.exchange_rate_type
1117: , head.exchange_rate
1118: , head.exchange_date
1119: FROM
1120: ap_invoices_all head
1121: , ap_invoice_distributions_all det
1122: , po_distributions_all po
1123: WHERE head.invoice_id = det.invoice_id
1124: -- Modified by Jia for bug#7675638 on 30-Dec-2008, Begin

Line 1235: ap_invoices_all head

1231: , head.exchange_rate_type
1232: , head.exchange_rate
1233: , head.exchange_date
1234: FROM
1235: ap_invoices_all head
1236: , ap_invoice_distributions_all det
1237: WHERE head.invoice_id = det.invoice_id
1238: -- Modified by Jia for bug#7675638 on 30-Dec-2008, Begin
1239: --------------------------------------------------------------