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_APPROVAL_MATCHED_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1558: po_distributions_ap_v PD,

1554: ,RSL.item_id -- l_rtxn_item_id
1555: ,PL.unit_meas_lookup_code -- l_po_uom
1556: ,PLL.match_option -- l_match_option
1557: FROM ap_invoice_distributions D,
1558: po_distributions_ap_v PD,
1559: rcv_transactions RTXN,
1560: rcv_shipment_lines RSL,
1561: po_lines PL,
1562: po_line_locations PLL

Line 1831: po_distributions_ap_v PD,

1827: ,nvl(PD.amount_ordered,0)
1828: - nvl(PD.amount_cancelled,0) -- l_po_amt
1829: ,PLL.match_option -- l_match_option
1830: FROM ap_invoice_distributions D,
1831: po_distributions_ap_v PD,
1832: rcv_transactions RTXN,
1833: rcv_shipment_lines RSL,
1834: po_lines PL,
1835: po_line_locations PLL

Line 3924: FROM po_distributions_ap_v PD

3920: p_calling_sequence;
3921:
3922: SELECT ROUND(SUM(nvl(PD.quantity_delivered, 0)), 5)
3923: INTO p_qty_delivered
3924: FROM po_distributions_ap_v PD
3925: WHERE PD.line_location_id = p_line_location_id;
3926:
3927: EXCEPTION
3928: WHEN NO_DATA_FOUND THEN

Line 3970: FROM po_distributions_ap_v PD

3966: SET final_match_flag = p_final_match_flag
3967: WHERE AID.invoice_id = p_invoice_id -- Bug 3489536
3968: AND AID.po_distribution_id IN
3969: (SELECT PD.po_distribution_id
3970: FROM po_distributions_ap_v PD
3971: WHERE line_location_id = p_line_location_id);
3972:
3973: UPDATE ap_invoice_lines AIL
3974: SET final_match_flag = p_final_match_flag

Line 4095: po_distributions_ap_v PD,

4091: SELECT PD.line_location_id,
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

Line 4111: po_distributions_ap_v PD,

4107: SELECT PD.line_location_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

Line 4140: FROM po_distributions_ap_v PD,

4136: DECODE(PD.po_release_id, NULL, PD.po_header_id,
4137: PD.po_release_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

Line 5603: FROM po_distributions_ap_v PD

5599: nvl(PD.amount_billed,0)
5600: )
5601: )
5602: INTO p_ship_trx_amt_var
5603: FROM po_distributions_ap_v PD
5604: WHERE PD.line_location_id = p_line_location_id;
5605:
5606: p_ship_trx_amt_var := p_ship_trx_amt_var - l_po_total;
5607:

Line 5860: FROM ap_invoice_distributions D, po_distributions_ap_v PD

5856: END IF;
5857:
5858: SELECT SUM( NVL(D.base_amount, 0))
5859: INTO p_rate_amt_var
5860: FROM ap_invoice_distributions D, po_distributions_ap_v PD
5861: WHERE D.po_distribution_id = PD.po_distribution_id
5862: AND PD.line_location_id = p_line_location_id
5863: AND D.invoice_id = p_invoice_id
5864: AND D.line_type_lookup_code = 'ERV';

Line 6001: FROM po_distributions_ap_v PD

5997: SELECT SUM((NVL(PD.quantity_ordered, 0) -
5998: NVL(PD.quantity_cancelled, 0)) * p_po_price
5999: * DECODE(p_inv_curr_code, p_base_curr_code,1, PD.rate))
6000: INTO l_po_total
6001: FROM po_distributions_ap_v PD
6002: WHERE PD.line_location_id = p_line_location_id;
6003:
6004: --Bug6824860 this SQl should not consider lines which are not matched, but
6005: --have PO dist ID stamped,

Line 6016: , po_distributions_ap_v PD

6012: nvl(D.base_amount,D.amount/*,(D.amount * DECODE(I.exchange_rate, null,
6013: PD.rate, I.exchange_rate))*/))) /*commented in bug: 14726598 as additional fix*/
6014: INTO p_ship_base_amt_var
6015: FROM ap_invoice_distributions D
6016: , po_distributions_ap_v PD
6017: , ap_invoices I
6018: , ap_invoice_lines L --Bug6824860
6019: WHERE D.po_distribution_id = PD.po_distribution_id
6020: AND PD.line_location_id = p_line_location_id

Line 6059: FROM po_distributions_ap_v PD

6055: NVL(PD.amount_cancelled, 0))
6056: * DECODE(p_inv_curr_code, p_base_curr_code,1,
6057: PD.rate))
6058: INTO l_po_total
6059: FROM po_distributions_ap_v PD
6060: WHERE PD.line_location_id = p_line_location_id;
6061:
6062: --Bug6824860 this SQl should not consider lines which are not matched, but
6063: --have PO dist ID stamped,

Line 6074: , po_distributions_ap_v PD

6070: nvl(D.base_amount,D.amount/*,(D.amount * DECODE(I.exchange_rate, null,
6071: PD.rate, I.exchange_rate))*/))) /*commented in bug: 14726598 as additional fix*/
6072: INTO p_ship_base_amt_var
6073: FROM ap_invoice_distributions D
6074: , po_distributions_ap_v PD
6075: , ap_invoices I
6076: , ap_invoice_lines L --Bug6824860
6077: WHERE D.po_distribution_id = PD.po_distribution_id
6078: AND PD.line_location_id = p_line_location_id