[Home] [Help]
296: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
297: FROM ap_invoice_distributions D,
298: ap_invoices I,
299: po_distributions PD,
300: po_line_locations PLL,
301: po_lines PL,
302: rcv_transactions RTXN,
303: rcv_shipment_lines RSL,
304: ap_invoice_lines_all ail
367: ap_invoice_distributions retain_D, --bug 9242891 retainage invoice dist
368: ap_invoices I, --retainage release invoice
369: ap_invoices retain_I, --bug 9242891 retainage invoice
370: po_distributions PD,
371: po_line_locations PLL,
372: po_lines PL,
373: rcv_transactions RTXN,
374: rcv_shipment_lines RSL
375: WHERE I.invoice_id = p_invoice_id
438: l_erv_acct_invalid_exists VARCHAR2(1) := 'N';
439: l_variance_success BOOLEAN := FALSE;
440: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
441: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
442: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
446: l_uom_conv_rate NUMBER := NULL;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
449: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
450: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
451: l_po_erv NUMBER := 0;
452: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
453:
454: l_key_value NUMBER;
457: l_debug_loc VARCHAR2(30) := 'Exec_Matched_Variance_Checks';
458: l_curr_calling_sequence VARCHAR2(2000);
459: l_debug_info VARCHAR2(2000);
460: l_debug_context VARCHAR2(2000);
461: l_match_basis PO_LINE_LOCATIONS.matching_basis%TYPE; /*Amount Based Matching */
462: l_cnt PLS_INTEGER DEFAULT 0; --bug 9242891
463: l_api_name VARCHAR2(100); --Bug 9242891
464:
465: BEGIN
1558: po_distributions_ap_v PD,
1559: rcv_transactions RTXN,
1560: rcv_shipment_lines RSL,
1561: po_lines PL,
1562: po_line_locations PLL
1563: WHERE D.invoice_id = p_invoice_id
1564: AND D.po_distribution_id = PD.po_distribution_id
1565: AND NVL(D.match_status_flag, 'N') IN ('N', 'S', 'A')
1566: AND NVL(D.posted_flag, 'N') IN ('N', 'P')
1831: po_distributions_ap_v PD,
1832: rcv_transactions RTXN,
1833: rcv_shipment_lines RSL,
1834: po_lines PL,
1835: po_line_locations PLL
1836: WHERE D.invoice_id = p_invoice_id
1837: AND D.po_distribution_id = PD.po_distribution_id
1838: AND NVL(D.match_status_flag, 'N') IN ('N', 'S', 'A')
1839: AND NVL(D.posted_flag, 'N') IN ('N', 'P')
2144: rcv_transactions RTXN,
2145: rcv_shipment_lines RSL,
2146: ap_invoice_lines L,
2147: ap_invoices I,
2148: po_line_locations PLL,
2149: po_headers PH,
2150: po_releases PR
2151: WHERE I.invoice_id = L.invoice_id
2152: AND L.po_line_location_id = PLL.line_location_id
2286: l_po_uom VARCHAR2(25);
2287: l_item_id NUMBER;
2288: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
2289: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign
2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2294: l_payment_type po_line_locations_all.payment_type%TYPE;
2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign
2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2294: l_payment_type po_line_locations_all.payment_type%TYPE;
2295: l_billed_amt NUMBER;
2296: l_amt_delivered NUMBER;
2297: l_amt_corrected NUMBER;
2298: l_ret_status VARCHAR2(100);
3772: p_calling_sequence;
3773:
3774: SELECT PLL.closed_code
3775: INTO p_po_closed_code
3776: FROM po_line_locations PLL
3777: WHERE line_location_id = p_line_location_id;
3778:
3779: EXCEPTION
3780: WHEN NO_DATA_FOUND THEN
4092: 'CANT CLOSE PO'
4093: FROM ap_invoice_distributions AID,
4094: ap_holds AH,
4095: po_distributions_ap_v PD,
4096: po_line_locations PLL --Bug 3489536
4097: WHERE AH.invoice_id = p_invoice_id
4098: AND AH.hold_lookup_code = 'CANT CLOSE PO'
4099: AND AH.release_lookup_code IS NULL
4100: AND AH.invoice_id = AID.invoice_id
4108: 'CANT TRY PO CLOSE'
4109: FROM ap_invoice_distributions AID,
4110: ap_holds AH,
4111: po_distributions_ap_v PD,
4112: po_line_locations PLL --Bug 3489536
4113: WHERE AH.invoice_id = p_invoice_id
4114: AND AH.hold_lookup_code = 'CANT TRY PO CLOSE'
4115: AND AH.release_lookup_code IS NULL
4116: AND AH.invoice_id = AID.invoice_id
4138: PH.segment1,
4139: MAX(aid.accounting_date) Accounting_date
4140: FROM po_distributions_ap_v PD,
4141: ap_invoice_distributions AID,
4142: po_line_locations PLL,
4143: po_headers PH,
4144: po_releases PR
4145: WHERE AID.invoice_id = p_invoice_id
4146: AND AID.final_match_flag = 'Y'
4379:
4380: --bug 7696098 removed the quotes in p_api_version => '1.0'
4381: PO_AP_INVOICE_MATCH_GRP.set_final_match_flag
4382: (p_api_version => 1.0,
4383: p_entity_type => 'PO_LINE_LOCATIONS',
4384: p_entity_id_tbl => l_po_line_loc_tab,
4385: p_final_match_flag => 'Y',
4386: p_init_msg_list => FND_API.G_FALSE ,
4387: p_commit => FND_API.G_FALSE ,
5076: ,0)
5077: )
5078: ,5)
5079: INTO p_qty_billed
5080: FROM po_line_locations PLL
5081: WHERE PLL.line_location_id = p_line_location_id;
5082: */
5083:
5084: --bug 9309310
5086: 0, (nvl(pll.quantity_financed,0) + nvl(pll.quantity_billed,0) - nvl(pll.quantity_recouped,0))
5087: )
5088: ,15)
5089: INTO p_qty_billed
5090: FROM po_line_locations PLL
5091: WHERE PLL.line_location_id = p_line_location_id;
5092:
5093: EXCEPTION
5094: WHEN OTHERS THEN
5317: ,0)
5318: )
5319: ,5)
5320: INTO p_amt_billed
5321: FROM po_line_locations PLL
5322: WHERE PLL.line_location_id = p_line_location_id;
5323: */
5324:
5325: SELECT ROUND(DECODE(l_inv_amt_billed,0,
5326: 0, (nvl(PLL.amount_financed,0) + nvl(PLL.amount_billed,0) - nvl(PLL.amount_recouped,0))
5327: )
5328: ,5)
5329: INTO p_amt_billed
5330: FROM po_line_locations PLL
5331: WHERE PLL.line_location_id = p_line_location_id;
5332:
5333: EXCEPTION
5334: WHEN OTHERS THEN
5567: / FC.minimum_accountable_unit)
5568: * FC.minimum_accountable_unit)
5569: INTO l_po_total
5570: FROM fnd_currencies FC,
5571: po_line_locations PLL,
5572: po_headers PH
5573: WHERE PLL.line_location_id = p_line_location_id
5574: AND PH.po_header_id = PLL.po_header_id
5575: AND FC.currency_code = PH.currency_code;
5585: NVL(PLL.amount_cancelled, 0))
5586: / FC.minimum_accountable_unit)
5587: * FC.minimum_accountable_unit)
5588: INTO l_po_total
5589: FROM fnd_currencies FC, po_line_locations PLL, po_headers PH
5590: WHERE PLL.line_location_id = p_line_location_id
5591: AND PH.po_header_id = PLL.po_header_id
5592: AND FC.currency_code = PH.currency_code;
5593:
6538: where invoice_id = p_invoice_id
6539: and po_line_location_id is not null --Bug16406697
6540: and line_type_lookup_code not in ('TAX','PREPAY');
6541:
6542: l_line_location_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;
6543:
6544: --End9868268
6545:
6546: l_debug_loc VARCHAR2(30):='exec_partial_funds_check';
6563: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
6564: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
6565: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
6566: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
6567: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
6568: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
6569: l_amount_received PO_LINE_LOCATIONS.amount_received%TYPE;
6570: l_hold_name VARCHAR2(30);
6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
6564: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
6565: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
6566: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
6567: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
6568: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
6569: l_amount_received PO_LINE_LOCATIONS.amount_received%TYPE;
6570: l_hold_name VARCHAR2(30);
6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
6572: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
6565: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
6566: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
6567: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
6568: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
6569: l_amount_received PO_LINE_LOCATIONS.amount_received%TYPE;
6570: l_hold_name VARCHAR2(30);
6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
6572: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
6573: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
6567: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
6568: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
6569: l_amount_received PO_LINE_LOCATIONS.amount_received%TYPE;
6570: l_hold_name VARCHAR2(30);
6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
6572: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
6573: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
6574: l_po_header_id ap_invoice_lines_all.po_header_id%TYPE;
6575: