[Home] [Help]
1335: ,RSL.item_id -- l_rtxn_item_id
1336: ,PL.unit_meas_lookup_code -- l_po_uom
1337: ,PLL.match_option -- l_match_option
1338: FROM ap_invoice_distributions D,
1339: po_distributions_ap_v PD,
1340: rcv_transactions RTXN,
1341: rcv_shipment_lines RSL,
1342: po_lines PL,
1343: po_line_locations PLL
1599: ,nvl(PD.amount_ordered,0)
1600: - nvl(PD.amount_cancelled,0) -- l_po_amt
1601: ,PLL.match_option -- l_match_option
1602: FROM ap_invoice_distributions D,
1603: po_distributions_ap_v PD,
1604: rcv_transactions RTXN,
1605: rcv_shipment_lines RSL,
1606: po_lines PL,
1607: po_line_locations PLL
3477: p_calling_sequence;
3478:
3479: SELECT ROUND(SUM(nvl(PD.quantity_delivered, 0)), 5)
3480: INTO p_qty_delivered
3481: FROM po_distributions_ap_v PD
3482: WHERE PD.line_location_id = p_line_location_id;
3483:
3484: EXCEPTION
3485: WHEN NO_DATA_FOUND THEN
3523: SET final_match_flag = p_final_match_flag
3524: WHERE AID.invoice_id = p_invoice_id -- Bug 3489536
3525: AND AID.po_distribution_id IN
3526: (SELECT PD.po_distribution_id
3527: FROM po_distributions_ap_v PD
3528: WHERE line_location_id = p_line_location_id);
3529:
3530: UPDATE ap_invoice_lines AIL
3531: SET final_match_flag = p_final_match_flag
3648: SELECT PD.line_location_id,
3649: 'CANT CLOSE PO'
3650: FROM ap_invoice_distributions AID,
3651: ap_holds AH,
3652: po_distributions_ap_v PD,
3653: po_line_locations PLL --Bug 3489536
3654: WHERE AH.invoice_id = p_invoice_id
3655: AND AH.hold_lookup_code = 'CANT CLOSE PO'
3656: AND AH.release_lookup_code IS NULL
3664: SELECT PD.line_location_id,
3665: 'CANT TRY PO CLOSE'
3666: FROM ap_invoice_distributions AID,
3667: ap_holds AH,
3668: po_distributions_ap_v PD,
3669: po_line_locations PLL --Bug 3489536
3670: WHERE AH.invoice_id = p_invoice_id
3671: AND AH.hold_lookup_code = 'CANT TRY PO CLOSE'
3672: AND AH.release_lookup_code IS NULL
3693: DECODE(PD.po_release_id, NULL, PD.po_header_id,
3694: PD.po_release_id),
3695: PH.segment1,
3696: MAX(aid.accounting_date) Accounting_date
3697: FROM po_distributions_ap_v PD,
3698: ap_invoice_distributions AID,
3699: po_line_locations PLL,
3700: po_headers PH,
3701: po_releases PR
5177: nvl(PD.amount_billed,0)
5178: )
5179: )
5180: INTO p_ship_trx_amt_var
5181: FROM po_distributions_ap_v PD
5182: WHERE PD.line_location_id = p_line_location_id;
5183:
5184: p_ship_trx_amt_var := p_ship_trx_amt_var - l_po_total;
5185:
5434: END IF;
5435:
5436: SELECT SUM( NVL(D.base_amount, 0))
5437: INTO p_rate_amt_var
5438: FROM ap_invoice_distributions D, po_distributions_ap_v PD
5439: WHERE D.po_distribution_id = PD.po_distribution_id
5440: AND PD.line_location_id = p_line_location_id
5441: AND D.invoice_id = p_invoice_id
5442: AND D.line_type_lookup_code = 'ERV';
5570: SELECT SUM((NVL(PD.quantity_ordered, 0) -
5571: NVL(PD.quantity_cancelled, 0)) * p_po_price
5572: * DECODE(p_inv_curr_code, p_base_curr_code,1, PD.rate))
5573: INTO l_po_total
5574: FROM po_distributions_ap_v PD
5575: WHERE PD.line_location_id = p_line_location_id;
5576:
5577: ELSE
5578:
5582: NVL(PD.amount_cancelled, 0))
5583: * DECODE(p_inv_curr_code, p_base_curr_code,1,
5584: PD.rate))
5585: INTO l_po_total
5586: FROM po_distributions_ap_v PD
5587: WHERE PD.line_location_id = p_line_location_id;
5588:
5589: END IF; -- Amount Based Matching If condition ends
5590:
5599: nvl(D.base_amount,(D.amount * DECODE(I.exchange_rate, null,
5600: PD.rate, I.exchange_rate)))))
5601: INTO p_ship_base_amt_var
5602: FROM ap_invoice_distributions D
5603: , po_distributions_ap_v PD
5604: , ap_invoices I
5605: , ap_invoice_lines L --Bug6824860
5606: WHERE D.po_distribution_id = PD.po_distribution_id
5607: AND PD.line_location_id = p_line_location_id