[Home] [Help]
450: ,'Y' insert_flag
451: ,DIST.historical_flag historical_flag
452: ,DIST.PRepay_distribution_id PRepay_distribution_id
453: ,SELF_ASSESSED_FLAG ---Bug 13602288: Self Assessed Tax Changes
454: FROM PO_Vendors VEND,
455: AP_Invoices INV,
456: AP_Invoice_Lines INVL,
457: PA_Transfer_AP_Invoices_View DIST,
458: PA_EXPENDITURE_TYPES TYPE
558: ,'Y' insert_flag
559: , paydist.payment_hist_dist_id
560: ,dist.pa_addition_flag pa_addition_flag --Bug# 5516855
561: from AP_Invoice_Payments_all pay,
562: po_vendors vend,
563: ap_invoices inv,
564: ap_payment_hist_dists paydist,
565: PA_Transfer_AP_Invoices_View DIST,
566: ap_checks chk
677: rcv_receiving_sub_ledger rcv_sub,
678: po_headers_all po_head,
679: po_lines_all po_line,
680: po_distributions_all po_dist,
681: po_vendors vend,
682: pa_expenditure_types type
683: where ((rcv_txn.destination_type_code ='EXPENSE' ) OR
684: (rcv_txn.destination_type_code='RECEIVING' AND
685: (rcv_txn.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING'))
794: ,nvl(DIST.exchange_date, INV.invoice_date) mrc_exchange_date
795: ,'CMT' fc_document_type
796: ,'Y' si_assets_addition_flag
797: ,'Y' insert_flag
798: FROM PO_Vendors VEND,
799: AP_Invoices_all INV,
800: PA_Transfer_AP_Invoices_View DIST
801: WHERE DIST.Invoice_Id = INV.Invoice_Id
802: AND DIST.Pa_Addition_Flag = 'W'
924: , paydist.payment_hist_dist_id
925: , l_PRepay_dist_id
926: FROM AP_Invoice_Payments Pay,
927: ap_payment_hist_dists Paydist,
928: PO_Vendors VEND,
929: AP_Invoices INV,
930: Ap_Invoice_Distributions DIST,
931: PA_EXPENDITURE_TYPES TYPE,
932: ap_checks chk
1020: ,'Y' si_assets_addition_flag
1021: ,'Y' insert_flag
1022: ,l_pay_hist_id
1023: ,DIST2.PRepay_distribution_id PRepay_distribution_id
1024: FROM PO_Vendors VEND,
1025: AP_Invoices INV,
1026: AP_Prepay_APP_Dists PDIST,
1027: AP_INVOICE_DISTRIBUTIONS DIST1,
1028: AP_INVOICE_DISTRIBUTIONS DIST2,