[Home] [Help]
1111: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1112: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1113: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1114: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1115: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);
1116:
1117: TYPE dist_tab_type IS TABLE OF dist_record_type INDEX BY BINARY_INTEGER;
1118:
1119: l_dist_tab dist_tab_type;
1116:
1117: TYPE dist_tab_type IS TABLE OF dist_record_type INDEX BY BINARY_INTEGER;
1118:
1119: l_dist_tab dist_tab_type;
1120: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1121: l_debug_info VARCHAR2(2000);
1122: l_api_name VARCHAR2(50);
1123:
1124:
1128: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1129: pll.matching_basis
1130: FROM ap_invoice_distributions_v aid,
1131: ap_invoices ai,
1132: po_line_locations pll
1133: WHERE pll.line_location_id = P_Po_Line_Location_Id
1134: AND pll.shipment_type <> 'PREPAYMENT'
1135: AND aid.line_location_id =pll.line_location_id
1136: AND aid.invoice_id = ai.invoice_id
1143: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1144: pll.matching_basis
1145: from ap_invoice_distributions aid,
1146: po_distributions_all pd,
1147: po_line_locations pll
1148: where pll.line_location_id = p_po_line_location_id
1149: and pll.shipment_type <> 'PREPAYMENT'
1150: and aid.po_distribution_id = pd.po_distribution_id
1151: and pd.line_location_id = pll.line_location_id
1265: END IF;
1266:
1267: IF (l_matching_basis = 'QUANTITY') THEN
1268:
1269: UPDATE po_line_locations
1270: SET quantity_financed = l_total_shipment_qty_invoiced,
1271: quantity_recouped = l_total_shipment_qty_applied,
1272: quantity_billed = nvl(quantity_billed,0) - (l_total_shipment_qty_invoiced - l_total_shipment_qty_applied)
1273: WHERE line_location_id = p_po_line_location_id
1274: AND quantity_financed IS NULL;
1275:
1276: ELSIF (l_matching_basis = 'AMOUNT') THEN
1277:
1278: UPDATE po_line_locations
1279: SET amount_financed = l_total_shipment_amt_invoiced,
1280: amount_recouped = l_total_shipment_amt_applied,
1281: amount_billed = nvl(amount_billed,0) - (l_total_shipment_amt_invoiced - l_total_shipment_amt_applied)
1282: WHERE line_location_id = p_po_line_location_id
1321: ai.invoice_id,ail.line_number) prepay_amount_remaining,
1322: max(aip.accounting_date) prepayment_payment_date
1323: FROM ap_invoices ai,
1324: ap_invoice_lines ail,
1325: po_line_locations pll,
1326: ap_invoice_payments aip
1327: WHERE ai.invoice_id = ail.invoice_id
1328: AND ail.po_line_id = p_po_line_id
1329: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1791: pll.matching_basis,
1792: pll.line_location_id
1793: FROM rcv_transactions rcv,
1794: rcv_shipment_lines rsl,
1795: po_line_locations pll
1796: WHERE rcv.shipment_line_id = rsl.shipment_line_id
1797: AND rsl.shipment_line_id = p_rcv_shipment_line_id
1798: AND pll.line_location_id = rcv.po_line_location_id
1799: AND rcv.transaction_type IN ('RECEIVE','MATCH');
1810:
1811: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
1812:
1813: l_rcv_shipment_line_id RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID%TYPE;
1814: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
1815: l_total_match_quantity NUMBER;
1816: l_total_match_amount NUMBER;
1817:
1818: l_match_unit_price NUMBER;
1818: l_match_unit_price NUMBER;
1819: l_match_quantity NUMBER;
1820: l_match_amount NUMBER;
1821: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1822: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
1823: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1824: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1825: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1826: l_retained_amount AP_INVOICE_LINES.RETAINED_AMOUNT%TYPE;
2311: pll.matching_basis,
2312: pll.line_location_id
2313: FROM rcv_transactions rcv,
2314: rcv_shipment_lines rsl,
2315: po_line_locations pll
2316: WHERE rcv.shipment_line_id = rsl.shipment_line_id
2317: AND rsl.shipment_line_id = p_rcv_shipment_line_id
2318: AND pll.line_location_id = rcv.po_line_location_id
2319: AND rcv.transaction_type IN ('RECEIVE','MATCH');
2317: AND rsl.shipment_line_id = p_rcv_shipment_line_id
2318: AND pll.line_location_id = rcv.po_line_location_id
2319: AND rcv.transaction_type IN ('RECEIVE','MATCH');
2320:
2321: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
2322: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2323: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
2324: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2325:
2319: AND rcv.transaction_type IN ('RECEIVE','MATCH');
2320:
2321: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
2322: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2323: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
2324: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2325:
2326: l_ordered_qty NUMBER;
2327: l_cancelled_qty NUMBER;
2506: (QUANTITY - NVL(QUANTITY_CANCELLED,0))*PRICE_OVERRIDE,
2507: (AMOUNT - NVL(AMOUNT_CANCELLED,0))),0),
2508: P_curr_code)
2509: INTO L_FULL_AMT
2510: FROM PO_LINE_LOCATIONS_ALL
2511: WHERE LINE_LOCATION_ID = P_po_line_location_id;
2512:
2513: RETURN L_FULL_AMT;
2514: