[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)
199: Into l_po_line_location_id,
200: l_vendor_id,
201: l_vendor_site_id,
202: l_ship_to_location_id
203: From rcv_transactions RCV,
204: rcv_shipment_lines RSL
205: Where RCV.transaction_id = l_othr_chrg_tab(1).rcv_txn_id
206: And RCV.shipment_line_id = RSL.shipment_line_id
207: And rownum < 2;
1432: 'N', --rcv_charge_addition_flag
1433: NULL --pay_awt_group_id bug9689194
1434: FROM ap_invoice_lines AIL,
1435: gl_code_combinations GCC,
1436: rcv_transactions rcv
1437: WHERE ail.invoice_id = x_invoice_id
1438: AND ail.line_number = x_invoice_line_number
1439: AND ail.rcv_transaction_id = rcv.transaction_id
1440: AND gcc.code_combination_id = ail.default_dist_ccid
1469: 'INVENTORY', PD.expenditure_organization_id), --expenditure_organization_id
1470: DECODE(PD.destination_type_code,
1471: 'EXPENSE', PD.award_id) --award_id
1472: FROM ap_invoice_distributions_all aid,
1473: rcv_transactions rcv,
1474: po_distributions_all pd
1475: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
1476: AND aid.rcv_transaction_id = rcv.transaction_id
1477: AND rcv.po_distribution_id = pd.po_distribution_id)