DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on PO_LINE_TYPES

Line 1184: po_line_types PLT,

1180: -- :
1181: p_chg.line_changes.t_manual_price_change_flag(i),
1182: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1183: FROM po_lines POL,
1184: po_line_types PLT,
1185: po_headers_all POHA,
1186: mtl_system_items_b MSI,
1187: financials_system_parameters FSP
1188: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)

Line 1341: po_line_types PLT,

1337: p_chg.shipment_changes.c_preferred_grade(i) -- INVCONV sschinch 09/07/04
1338: --p_chg.shipment_changes.c_payment_type(i)
1339: FROM po_line_locations PLL,
1340: po_lines POL,
1341: po_line_types PLT,
1342: mtl_system_items_b MSI,
1343: financials_system_parameters FSP
1344: WHERE PLL.line_location_id =
1345: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment

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

1462: p_chg.distribution_changes.c_distribution_num(i),
1463: p_chg.distribution_changes.c_encumbered_flag(i),
1464: p_chg.distribution_changes.c_req_distribution_id(i),
1465: p_chg.distribution_changes.c_creation_date(i)
1466: FROM po_distributions POD, po_lines POL, po_line_types PLT,po_line_locations_all PLL -- 1467: WHERE POD.po_distribution_id =
1468: NVL( p_chg.distribution_changes.parent_distribution_id(i), -- split dist
1469: p_chg.distribution_changes.po_distribution_id(i) ) -- existing dist
1470: AND POL.po_line_id = POD.po_line_id -- JOIN