DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on PO_LINE_TYPES

Line 1161: po_line_types PLT,

1157: -- :
1158: p_chg.line_changes.t_manual_price_change_flag(i),
1159: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1160: FROM po_lines POL,
1161: po_line_types PLT,
1162: po_headers_all POHA,
1163: mtl_system_items_b MSI,
1164: financials_system_parameters FSP
1165: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)

Line 1318: po_line_types PLT,

1314: p_chg.shipment_changes.c_preferred_grade(i) -- INVCONV sschinch 09/07/04
1315: --p_chg.shipment_changes.c_payment_type(i)
1316: FROM po_line_locations PLL,
1317: po_lines POL,
1318: po_line_types PLT,
1319: mtl_system_items_b MSI,
1320: financials_system_parameters FSP
1321: WHERE PLL.line_location_id =
1322: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment

Line 1443: FROM po_distributions POD, po_lines POL, po_line_types PLT,po_line_locations_all PLL --

1439: p_chg.distribution_changes.c_distribution_num(i),
1440: p_chg.distribution_changes.c_encumbered_flag(i),
1441: p_chg.distribution_changes.c_req_distribution_id(i),
1442: p_chg.distribution_changes.c_creation_date(i)
1443: FROM po_distributions POD, po_lines POL, po_line_types PLT,po_line_locations_all PLL -- 1444: WHERE POD.po_distribution_id =
1445: NVL( p_chg.distribution_changes.parent_distribution_id(i), -- split dist
1446: p_chg.distribution_changes.po_distribution_id(i) ) -- existing dist
1447: AND POL.po_line_id = POD.po_line_id -- JOIN