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 201: FROM po_headers_all ph, po_lines_all pl

197: UPDATE po_line_locations_all pll
198: SET pll.tax_attribute_update_code =
199: NVL(
200: (SELECT NVL(pl.tax_attribute_update_code, ph.tax_attribute_update_code)
201: FROM po_headers_all ph, po_lines_all pl
202: WHERE pll.po_line_id = pl.po_line_id
203: AND pll.po_header_id = ph.po_header_id
204: -- following AND written only for clarity
205: --AND (pl.tax_attribute_update_code IS NOT NULL

Line 425: FROM po_line_locations_all pll, po_lines_all pl

421: SET zxlgt.product_type =
422: (SELECT DECODE(pl.purchase_basis,
423: 'GOODS', 'GOODS',
424: 'SERVICES')
425: FROM po_line_locations_all pll, po_lines_all pl
426: WHERE pll.line_location_id = zxlgt.trx_line_id
427: AND pll.po_line_id = pl.po_line_id)
428: WHERE zxlgt.product_type IS NULL
429: AND zxlgt.line_level_action = 'CREATE';

Line 823: UPDATE po_lines_all

819: WHERE zxlgt.trx_id=pr.po_release_id);
820:
821: d_progress := 480;
822: FORALL i IN 1..p_po_header_id_tbl.COUNT
823: UPDATE po_lines_all
824: SET tax_attribute_update_code = null
825: WHERE po_header_id = p_po_header_id_tbl(i);
826:
827: d_progress := 490;

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

3098: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3099: WHERE p_calling_program = 'PDOI'
3100: AND pll.tax_name IS NOT NULL)
3101: ,pll.ship_to_organization_id --Bug#6902111
3102: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3103: zx_lines_det_factors zxldet, po_vendors pv,
3104: po_vendor_sites_all pvs, mtl_system_items_b msib
3105: WHERE ph.po_header_id = pll.po_header_id
3106: AND pl.po_line_id = pll.po_line_id

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

3398: -- Join with vendor tables to get party and party site information
3399: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3400: LEFT OUTER JOIN po_vendor_sites_all pvs
3401: ON (ph.vendor_site_id = pvs.vendor_site_id)
3402: ,po_lines_all pl--Blanket/Scheduled header and line
3403: -- Join with items table for item information
3404: LEFT OUTER JOIN mtl_system_items_b msib
3405: ON (pl.item_id = msib.inventory_item_id
3406: AND pl.org_id = msib.organization_id)

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

3778: ,pll.quantity --trx_line_quantity
3779: ,pd1.code_combination_id --account_ccid
3780: ,pd1.rate --currency_exchange_rate
3781: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
3782: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
3783: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
3784: AND pd1.line_location_id=pll.line_location_id
3785: AND pll.po_line_id=pl.po_line_id
3786: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

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

3871: ,pll.quantity --trx_line_quantity
3872: ,pd.code_combination_id --account_ccid
3873: ,pd.rate --currency_exchange_rate
3874: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
3875: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
3876: WHERE pd.po_header_id = p_po_header_id
3877: AND pd.line_location_id=pll.line_location_id
3878: AND pll.po_line_id = pl.po_line_id
3879: -- Conditions that determine that po line is 'Active'

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

3966: ,pll.quantity --trx_line_quantity
3967: ,pd1.code_combination_id --account_ccid
3968: ,pd1.rate --currency_exchange_rate
3969: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
3970: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
3971: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
3972: AND pd1.line_location_id=pll.line_location_id
3973: AND pll.po_line_id=pl.po_line_id
3974: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

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

4059: ,pll.quantity --trx_line_quantity
4060: ,pd.code_combination_id --account_ccid
4061: ,pd.rate --currency_exchange_rate
4062: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4063: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4064: WHERE pd.po_release_id = p_po_release_id
4065: AND pd.line_location_id = pll.line_location_id
4066: AND pll.po_line_id = pl.po_line_id
4067: -- Conditions that determine that po line is 'Active'

Line 4230: po_lines_all POL,

4226: FROM DUAL
4227: WHERE EXISTS
4228: (SELECT 'Y'
4229: FROM po_headers_all POH,
4230: po_lines_all POL,
4231: po_line_locations_all PLL,
4232: po_distributions_all POD
4233: WHERE POH.po_header_id = p_po_header_id
4234: AND POH.po_header_id = POL.po_header_id

Line 5011: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;

5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5009: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5010: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5011: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5012: l_price PO_LINES_ALL.UNIT_PRICE%type;
5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5015: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;

Line 5012: l_price PO_LINES_ALL.UNIT_PRICE%type;

5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5009: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5010: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5011: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5012: l_price PO_LINES_ALL.UNIT_PRICE%type;
5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --
5015: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5016: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;

Line 5117: FROM po_lines_all

5113: SELECT unit_meas_lookup_code,
5114: unit_price
5115: INTO l_uom,
5116: l_price
5117: FROM po_lines_all
5118: WHERE po_line_id =p_doc_level_id;
5119:
5120: IF nvl(l_uom,-99) = nvl(p_uom,-99) AND
5121: nvl(l_price,-99) = nvl(p_price,-99)

Line 5561: FROM po_lines_all pl

5557:
5558: l_line_id_tbl := null; l_line_tauc_tbl := null;
5559: SELECT pl.po_line_id, pl.tax_attribute_update_code
5560: BULK COLLECT INTO l_line_id_tbl, l_line_tauc_tbl
5561: FROM po_lines_all pl
5562: WHERE pl.po_header_id = p_po_header_id_tbl(i);
5563:
5564: FOR j IN 1..l_line_id_tbl.COUNT LOOP
5565: PO_LOG.stmt(d_module_base,d_progress,' po_line_id = '||l_line_id_tbl(j)||':'||l_line_tauc_tbl(j));