eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_MATCHING_UTILS_PKG dependencies on PO_LINE_LOCATIONS

Line 1050: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);

1046: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1047: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1048: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1049: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1050: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);
1051:
1052: TYPE dist_tab_type IS TABLE OF dist_record_type INDEX BY BINARY_INTEGER;
1053:
1054: l_dist_tab dist_tab_type;

Line 1055: l_matching_basis po_line_locations_all.matching_basis%TYPE;

1051:
1052: TYPE dist_tab_type IS TABLE OF dist_record_type INDEX BY BINARY_INTEGER;
1053:
1054: l_dist_tab dist_tab_type;
1055: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1056: l_debug_info VARCHAR2(2000);
1057: l_api_name VARCHAR2(50);
1058:
1059:

Line 1067: po_line_locations pll

1063: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1064: pll.matching_basis
1065: FROM ap_invoice_distributions_v aid,
1066: ap_invoices ai,
1067: po_line_locations pll
1068: WHERE pll.line_location_id = P_Po_Line_Location_Id
1069: AND pll.shipment_type <> 'PREPAYMENT'
1070: AND aid.line_location_id =pll.line_location_id
1071: AND aid.invoice_id = ai.invoice_id

Line 1082: po_line_locations pll

1078: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1079: pll.matching_basis
1080: from ap_invoice_distributions aid,
1081: po_distributions_all pd,
1082: po_line_locations pll
1083: where pll.line_location_id = p_po_line_location_id
1084: and pll.shipment_type <> 'PREPAYMENT'
1085: and aid.po_distribution_id = pd.po_distribution_id
1086: and pd.line_location_id = pll.line_location_id

Line 1204: UPDATE po_line_locations

1200: END IF;
1201:
1202: IF (l_matching_basis = 'QUANTITY') THEN
1203:
1204: UPDATE po_line_locations
1205: SET quantity_financed = l_total_shipment_qty_invoiced,
1206: quantity_recouped = l_total_shipment_qty_applied,
1207: quantity_billed = nvl(quantity_billed,0) - (l_total_shipment_qty_invoiced - l_total_shipment_qty_applied)
1208: WHERE line_location_id = p_po_line_location_id

Line 1213: UPDATE po_line_locations

1209: AND quantity_financed IS NULL;
1210:
1211: ELSIF (l_matching_basis = 'AMOUNT') THEN
1212:
1213: UPDATE po_line_locations
1214: SET amount_financed = l_total_shipment_amt_invoiced,
1215: amount_recouped = l_total_shipment_amt_applied,
1216: amount_billed = nvl(amount_billed,0) - (l_total_shipment_amt_invoiced - l_total_shipment_amt_applied)
1217: WHERE line_location_id = p_po_line_location_id

Line 1260: po_line_locations pll,

1256: ai.invoice_id,ail.line_number) prepay_amount_remaining,
1257: max(aip.accounting_date) prepayment_payment_date
1258: FROM ap_invoices ai,
1259: ap_invoice_lines ail,
1260: po_line_locations pll,
1261: ap_invoice_payments aip
1262: WHERE ai.invoice_id = ail.invoice_id
1263: AND ail.po_line_id = p_po_line_id
1264: AND ai.invoice_type_lookup_code = 'PREPAYMENT'

Line 1727: po_line_locations pll

1723: pll.matching_basis,
1724: pll.line_location_id
1725: FROM rcv_transactions rcv,
1726: rcv_shipment_lines rsl,
1727: po_line_locations pll
1728: WHERE rcv.shipment_line_id = rsl.shipment_line_id
1729: AND rsl.shipment_line_id = p_rcv_shipment_line_id
1730: AND pll.line_location_id = rcv.po_line_location_id
1731: AND rcv.transaction_type IN ('RECEIVE','MATCH');

Line 1746: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;

1742:
1743: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
1744:
1745: l_rcv_shipment_line_id RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID%TYPE;
1746: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
1747: l_total_match_quantity NUMBER;
1748: l_total_match_amount NUMBER;
1749:
1750: l_match_unit_price NUMBER;

Line 1754: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;

1750: l_match_unit_price NUMBER;
1751: l_match_quantity NUMBER;
1752: l_match_amount NUMBER;
1753: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1754: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
1755: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1756: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1757: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1758: l_retained_amount AP_INVOICE_LINES.RETAINED_AMOUNT%TYPE;

Line 2245: po_line_locations pll

2241: pll.matching_basis,
2242: pll.line_location_id
2243: FROM rcv_transactions rcv,
2244: rcv_shipment_lines rsl,
2245: po_line_locations pll
2246: WHERE rcv.shipment_line_id = rsl.shipment_line_id
2247: AND rsl.shipment_line_id = p_rcv_shipment_line_id
2248: AND pll.line_location_id = rcv.po_line_location_id
2249: AND rcv.transaction_type IN ('RECEIVE','MATCH');

Line 2251: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;

2247: AND rsl.shipment_line_id = p_rcv_shipment_line_id
2248: AND pll.line_location_id = rcv.po_line_location_id
2249: AND rcv.transaction_type IN ('RECEIVE','MATCH');
2250:
2251: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
2252: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2253: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
2254: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2255:

Line 2253: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;

2249: AND rcv.transaction_type IN ('RECEIVE','MATCH');
2250:
2251: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
2252: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2253: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
2254: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2255:
2256: l_ordered_qty NUMBER;
2257: l_cancelled_qty NUMBER;