[Home] [Help]
26: from a invoice line or from the import.
27: X_line_type Line Type of the charge line. Can be either
28: FREIGHT or MISC
29: X_prorate_flag Flag which indicates whether x_total amount needs
30: to be prorated across all the rcv_transactions
31: X_account_id The dist_code_combination_id to be used when creating
32: the distributions. Can be NULL.
33: X_description Description to be stored on the invoice distributions
34: X_total_amount The total amount that needs to be matched(linked)
192: Into l_po_line_location_id,
193: l_vendor_id,
194: l_vendor_site_id,
195: l_ship_to_location_id
196: From rcv_transactions RCV,
197: rcv_shipment_lines RSL
198: Where RCV.transaction_id = l_othr_chrg_tab(1).rcv_txn_id
199: And RCV.shipment_line_id = RSL.shipment_line_id
200: And rownum < 2;
1343: /*,rcv.intended_use */
1344: 'N' --rcv_charge_addition_flag
1345: FROM ap_invoice_lines AIL,
1346: gl_code_combinations GCC,
1347: rcv_transactions rcv
1348: WHERE ail.invoice_id = x_invoice_id
1349: AND ail.line_number = x_invoice_line_number
1350: AND ail.rcv_transaction_id = rcv.transaction_id
1351: AND gcc.code_combination_id = ail.default_dist_ccid
1380: 'INVENTORY', PD.expenditure_organization_id), --expenditure_organization_id
1381: DECODE(PD.destination_type_code,
1382: 'EXPENSE', PD.award_id) --award_id
1383: FROM ap_invoice_distributions_all aid,
1384: rcv_transactions rcv,
1385: po_distributions_all pd
1386: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
1387: AND aid.rcv_transaction_id = rcv.transaction_id
1388: AND rcv.po_distribution_id = pd.po_distribution_id)