DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_LINES_ALL

Line 1074: FROM po_location_associations pla, oe_order_lines_all sl,

1070: sl.inventory_item_id,
1071: sl.source_type_code, decode(msi.inventory_asset_flag,
1072: 'Y', mp.material_account, nvl(msi.expense_account,
1073: mp.expense_account)), nvl(pla.location_id, -1)
1074: FROM po_location_associations pla, oe_order_lines_all sl,
1075: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1076: oe_order_headers sh
1077: WHERE sl.header_id = sh.header_id
1078: AND sl.line_id = p_line_id

Line 1643: FROM oe_order_lines_all

1639: option_number || '.' ||
1640: component_number || '.' ||
1641: service_number, '.')
1642: INTO l_line_num
1643: FROM oe_order_lines_all
1644: WHERE line_id = p_request_tbl(I).entity_id;
1645:
1646: IF l_process_flag is NULL THEN
1647:

Line 1738: FROM oe_order_lines_all

1734: option_number || '.' ||
1735: component_number || '.' ||
1736: service_number, '.')
1737: INTO l_line_num
1738: FROM oe_order_lines_all
1739: WHERE line_id = p_request_tbl(I).entity_id;
1740: Exception
1741: When Others Then
1742: /* Bug 4922019: Changes done to ATO configuration resutls in