[Home] [Help]
445: ,'Y' si_assets_addition_flag
446: ,'Y' insert_flag
447: ,DIST.historical_flag historical_flag
448: ,DIST.PRepay_distribution_id PRepay_distribution_id
449: FROM PO_Vendors VEND,
450: AP_Invoices INV,
451: AP_Invoice_Lines INVL,
452: PA_Transfer_AP_Invoices_View DIST,
453: PA_EXPENDITURE_TYPES TYPE
553: ,'Y' insert_flag
554: , paydist.payment_hist_dist_id
555: ,dist.pa_addition_flag pa_addition_flag --Bug# 5516855
556: from AP_Invoice_Payments_all pay,
557: po_vendors vend,
558: ap_invoices inv,
559: ap_payment_hist_dists paydist,
560: PA_Transfer_AP_Invoices_View DIST,
561: ap_checks chk
670: rcv_receiving_sub_ledger rcv_sub,
671: po_headers_all po_head,
672: po_lines_all po_line,
673: po_distributions_all po_dist,
674: po_vendors vend,
675: pa_expenditure_types type
676: where ((rcv_txn.destination_type_code ='EXPENSE' ) OR
677: (rcv_txn.destination_type_code='RECEIVING' AND
678: (rcv_txn.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING'))
787: ,nvl(DIST.exchange_date, INV.invoice_date) mrc_exchange_date
788: ,'CMT' fc_document_type
789: ,'Y' si_assets_addition_flag
790: ,'Y' insert_flag
791: FROM PO_Vendors VEND,
792: AP_Invoices_all INV,
793: PA_Transfer_AP_Invoices_View DIST
794: WHERE DIST.Invoice_Id = INV.Invoice_Id
795: AND DIST.Pa_Addition_Flag = 'W'
917: , paydist.payment_hist_dist_id
918: , l_PRepay_dist_id
919: FROM AP_Invoice_Payments Pay,
920: ap_payment_hist_dists Paydist,
921: PO_Vendors VEND,
922: AP_Invoices INV,
923: Ap_Invoice_Distributions DIST,
924: PA_EXPENDITURE_TYPES TYPE,
925: ap_checks chk
1013: ,'Y' si_assets_addition_flag
1014: ,'Y' insert_flag
1015: ,l_pay_hist_id
1016: ,DIST2.PRepay_distribution_id PRepay_distribution_id
1017: FROM PO_Vendors VEND,
1018: AP_Invoices INV,
1019: AP_Prepay_APP_Dists PDIST,
1020: AP_INVOICE_DISTRIBUTIONS DIST1,
1021: AP_INVOICE_DISTRIBUTIONS DIST2,