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_ETAX_UTILITY_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,

109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
115: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
116: org_id ap_invoice_distributions_all.org_id%TYPE,
117: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,

Line 917: FROM po_line_locations_all pll, po_distributions_all pd,

913: CURSOR PO_Info_from_dist (c_po_dist_Id IN NUMBER) IS
914: SELECT pll.org_id, pll.quantity, pll.line_location_id,
915: pll.po_header_id, nvl(ph.rate,1), pll.po_release_id, mum.uom_code,
916: pd.quantity_ordered, pll.price_override
917: FROM po_line_locations_all pll, po_distributions_all pd,
918: po_headers_all ph, mtl_units_of_measure mum
919: WHERE pd.po_distribution_id = c_po_dist_Id
920: AND pd.line_location_id = pll.line_location_id
921: AND pll.po_header_id = ph.po_header_id

Line 2703: po_distributions_all pd,

2699: ap_invoices_all ai,
2700: ap_supplier_sites_all pvs,
2701: ap_system_parameters_all asp,
2702: financials_system_params_all fsp,
2703: po_distributions_all pd,
2704: ap_invoice_lines_all parent_tax_line,
2705: ap_invoice_lines_all parent_item_line,
2706: ap_invoice_distributions_all parent_taxable_dist
2707: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID

Line 3050: po_distributions_all pd,

3046: ap_invoices_all ai,
3047: ap_supplier_sites_all pvs,
3048: ap_system_parameters_all asp,
3049: financials_system_params_all fsp,
3050: po_distributions_all pd,
3051: ap_invoice_lines_all parent_tax_line,
3052: ap_invoice_lines_all parent_item_line,
3053: ap_invoice_distributions_all parent_taxable_dist,
3054: ap_line_temp_gt dist

Line 3329: po_distributions_all pd,

3325: ap_invoice_distributions_all aid,
3326: ap_supplier_sites_all pvs,
3327: ap_system_parameters_all asp,
3328: financials_system_params_all fsp,
3329: po_distributions_all pd,
3330: ap_invoice_lines_all parent_tax_line,
3331: ap_invoice_lines_all parent_item_line,
3332: ap_invoice_distributions_all parent_taxable_dist
3333: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID

Line 3570: po_distributions_all pd,

3566: ap_invoice_distributions_all aid,
3567: ap_supplier_sites_all pvs,
3568: ap_system_parameters_all asp,
3569: financials_system_params_all fsp,
3570: po_distributions_all pd,
3571: ap_invoice_lines_all parent_tax_line,
3572: ap_invoice_lines_all parent_item_line,
3573: ap_invoice_distributions_all parent_taxable_dist
3574: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID

Line 3789: po_distributions_all pd,

3785: ap_invoices_all ai,
3786: ap_supplier_sites_all pvs,
3787: ap_system_parameters_all asp,
3788: financials_system_params_all fsp,
3789: po_distributions_all pd,
3790: ap_invoice_lines_all parent_item_line,
3791: ap_invoice_distributions_all parent_taxable_dist
3792: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3793: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3989: po_distributions_all pd,

3985: ap_self_assessed_tax_dist_all aid,
3986: ap_supplier_sites_all pvs,
3987: ap_system_parameters_all asp,
3988: financials_system_params_all fsp,
3989: po_distributions_all pd,
3990: ap_invoice_lines_all parent_tax_line,
3991: ap_invoice_lines_all parent_item_line,
3992: ap_invoice_distributions_all parent_taxable_dist
3993: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID

Line 9802: po_distributions_all PD,

9798: pl.unit_meas_lookup_code po_uom,
9799: D.matched_uom_lookup_code rcv_uom,
9800: rsl.item_id rcv_item_id
9801: FROM ap_invoice_distributions_all D,
9802: po_distributions_all PD,
9803: po_lines_all PL,
9804: po_line_locations_all PLL,
9805: rcv_transactions RTXN,
9806: rcv_shipment_lines RSL

Line 10507: FROM po_distributions_all pd

10503:
10504: l_debug_info := 'Querying on the basis of p_po_line_location_id' ;
10505: SELECT pd.code_combination_id
10506: INTO l_default_ccid
10507: FROM po_distributions_all pd
10508: WHERE pd.line_location_id = p_po_line_location_id
10509: AND rownum = 1;
10510:
10511: ELSIF p_po_distribution_id IS NOT NULL THEN

Line 10516: FROM po_distributions_all pd

10512:
10513: l_debug_info := 'Querying on the basis of p_po_distribution_id' ;
10514: SELECT pd.code_combination_id
10515: INTO l_default_ccid
10516: FROM po_distributions_all pd
10517: WHERE pd.line_location_id =
10518: (SELECT pod.line_location_id
10519: FROM po_distributions_all pod
10520: WHERE po_distribution_id = p_po_distribution_id )

Line 10519: FROM po_distributions_all pod

10515: INTO l_default_ccid
10516: FROM po_distributions_all pd
10517: WHERE pd.line_location_id =
10518: (SELECT pod.line_location_id
10519: FROM po_distributions_all pod
10520: WHERE po_distribution_id = p_po_distribution_id )
10521: AND rownum = 1;
10522:
10523: ELSIF p_rcv_shipment_line_id IS NOT NULL THEN

Line 10528: FROM po_distributions_all pd

10524:
10525: l_debug_info := 'Querying on the basis of p_rcv_shipment_line_id' ;
10526: SELECT pd.code_combination_id
10527: INTO l_default_ccid
10528: FROM po_distributions_all pd
10529: WHERE pd.line_location_id =
10530: (SELECT rcv.po_line_location_id
10531: FROM rcv_shipment_lines rcv
10532: WHERE rcv.shipment_line_id = p_rcv_shipment_line_id )

Line 10540: FROM po_distributions_all pd

10536:
10537: l_debug_info := 'Querying on the basis of p_rcv_transaction_id' ;
10538: SELECT pd.code_combination_id
10539: INTO l_default_ccid
10540: FROM po_distributions_all pd
10541: WHERE pd.line_location_id =
10542: (SELECT rcv.po_line_location_id
10543: FROM rcv_transactions rcv
10544: WHERE rcv.transaction_id = p_rcv_transaction_id )