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.PO_TAX_INTERFACE_PVT dependencies on PO_LINES_ALL

Line 223: po_lines_all pl

219: AND ROWNUM = 1),
220: NVL (pl.tax_attribute_update_code,
221: ph.tax_attribute_update_code))
222: FROM po_headers_all ph,
223: po_lines_all pl
224: WHERE pll.po_line_id = pl.po_line_id
225: AND pll.po_header_id = ph.po_header_id
226: ),
227: pll.tax_attribute_update_code

Line 482: FROM po_line_locations_all pll, po_lines_all pl

478: SET zxlgt.product_type =
479: (SELECT DECODE(pl.purchase_basis,
480: 'GOODS', 'GOODS',
481: 'SERVICES')
482: FROM po_line_locations_all pll, po_lines_all pl
483: WHERE pll.line_location_id = zxlgt.trx_line_id
484: AND pll.po_line_id = pl.po_line_id)
485: WHERE zxlgt.product_type IS NULL
486: AND zxlgt.line_level_action = 'CREATE';

Line 896: UPDATE po_lines_all

892: WHERE zxlgt.trx_id=pr.po_release_id);
893:
894: d_progress := 480;
895: FORALL i IN 1..p_po_header_id_tbl.COUNT
896: UPDATE po_lines_all
897: SET tax_attribute_update_code = null
898: WHERE po_header_id = p_po_header_id_tbl(i);
899:
900: d_progress := 490;

Line 3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

3289: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3290: WHERE p_calling_program = 'PDOI'
3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3294: zx_lines_det_factors zxldet, po_vendors pv,
3295: po_vendor_sites_all pvs, mtl_system_items_b msib
3296: WHERE ph.po_header_id = pll.po_header_id
3297: AND pl.po_line_id = pll.po_line_id

Line 3606: ,po_lines_all pl--Blanket/Scheduled header and line

3602: -- Join with vendor tables to get party and party site information
3603: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3604: LEFT OUTER JOIN po_vendor_sites_all pvs
3605: ON (ph.vendor_site_id = pvs.vendor_site_id)
3606: ,po_lines_all pl--Blanket/Scheduled header and line
3607: -- Join with items table for item information
3608: LEFT OUTER JOIN mtl_system_items_b msib
3609: ON (pl.item_id = msib.inventory_item_id
3610: AND pl.org_id = msib.organization_id)

Line 3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

3949: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3950: WHERE p_calling_program = 'PDOI'
3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3954: zx_lines_det_factors zxldet, po_vendors pv,
3955: po_vendor_sites_all pvs, mtl_system_items_b msib
3956: WHERE ph.po_header_id = pll.po_header_id
3957: AND pl.po_line_id = pll.po_line_id

Line 4262: ,po_lines_all pl--Blanket/Scheduled header and line

4258: -- Join with vendor tables to get party and party site information
4259: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
4260: LEFT OUTER JOIN po_vendor_sites_all pvs
4261: ON (ph.vendor_site_id = pvs.vendor_site_id)
4262: ,po_lines_all pl--Blanket/Scheduled header and line
4263: -- Join with items table for item information
4264: LEFT OUTER JOIN mtl_system_items_b msib
4265: ON (pl.item_id = msib.inventory_item_id
4266: AND pl.org_id = msib.organization_id)

Line 4666: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl

4662: ,pll.quantity --trx_line_quantity
4663: ,pd1.code_combination_id --account_ccid
4664: ,pd1.rate --currency_exchange_rate
4665: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
4666: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
4667: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
4668: AND pd1.line_location_id=pll.line_location_id
4669: AND pll.po_line_id=pl.po_line_id
4670: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 4759: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl

4755: ,pll.quantity --trx_line_quantity
4756: ,pd.code_combination_id --account_ccid
4757: ,pd.rate --currency_exchange_rate
4758: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4759: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4760: WHERE pd.po_header_id = p_po_header_id
4761: AND pd.line_location_id=pll.line_location_id
4762: AND pll.po_line_id = pl.po_line_id
4763: -- Conditions that determine that po line is 'Active'

Line 4863: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl

4859: ,pll.quantity --trx_line_quantity
4860: ,pd1.code_combination_id --account_ccid
4861: ,pd1.rate --currency_exchange_rate
4862: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
4863: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
4864: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
4865: AND pd1.line_location_id=pll.line_location_id
4866: AND pll.po_line_id=pl.po_line_id
4867: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 4956: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl

4952: ,pll.quantity --trx_line_quantity
4953: ,pd.code_combination_id --account_ccid
4954: ,pd.rate --currency_exchange_rate
4955: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4956: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4957: WHERE pd.po_release_id = p_po_release_id
4958: AND pd.line_location_id = pll.line_location_id
4959: AND pll.po_line_id = pl.po_line_id
4960: -- Conditions that determine that po line is 'Active'

Line 5123: po_lines_all POL,

5119: FROM DUAL
5120: WHERE EXISTS
5121: (SELECT 'Y'
5122: FROM po_headers_all POH,
5123: po_lines_all POL,
5124: po_line_locations_all PLL,
5125: po_distributions_all POD
5126: WHERE POH.po_header_id = p_po_header_id
5127: AND POH.po_header_id = POL.po_header_id

Line 5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;

5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;

Line 5907: l_price PO_LINES_ALL.UNIT_PRICE%type;

5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;

Line 6012: FROM po_lines_all

6008: SELECT unit_meas_lookup_code,
6009: unit_price
6010: INTO l_uom,
6011: l_price
6012: FROM po_lines_all
6013: WHERE po_line_id =p_doc_level_id;
6014:
6015: IF nvl(l_uom,-99) = nvl(p_uom,-99) AND
6016: nvl(l_price,-99) = nvl(p_price,-99)

Line 6457: FROM po_lines_all pl

6453:
6454: l_line_id_tbl := null; l_line_tauc_tbl := null;
6455: SELECT pl.po_line_id, pl.tax_attribute_update_code
6456: BULK COLLECT INTO l_line_id_tbl, l_line_tauc_tbl
6457: FROM po_lines_all pl
6458: WHERE pl.po_header_id = p_po_header_id_tbl(i);
6459:
6460: FOR j IN 1..l_line_id_tbl.COUNT LOOP
6461: PO_LOG.stmt(d_module_base,d_progress,' po_line_id = '||l_line_id_tbl(j)||':'||l_line_tauc_tbl(j));