DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_LINES_ALL

Line 1109: FROM po_location_associations pla, oe_order_lines_all sl,

1105: sl.inventory_item_id,
1106: sl.source_type_code, decode(msi.inventory_asset_flag,
1107: 'Y', mp.material_account, nvl(msi.expense_account,
1108: mp.expense_account)), nvl(pla.location_id, -1)
1109: FROM po_location_associations pla, oe_order_lines_all sl,
1110: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1111: oe_order_headers sh
1112: WHERE sl.header_id = sh.header_id
1113: AND sl.line_id = p_line_id

Line 1678: FROM oe_order_lines_all

1674: option_number || '.' ||
1675: component_number || '.' ||
1676: service_number, '.')
1677: INTO l_line_num
1678: FROM oe_order_lines_all
1679: WHERE line_id = p_request_tbl(I).entity_id;
1680:
1681: IF l_process_flag is NULL THEN
1682:

Line 1773: FROM oe_order_lines_all

1769: option_number || '.' ||
1770: component_number || '.' ||
1771: service_number, '.')
1772: INTO l_line_num
1773: FROM oe_order_lines_all
1774: WHERE line_id = p_request_tbl(I).entity_id;
1775: Exception
1776: When Others Then
1777: /* Bug 4922019: Changes done to ATO configuration resutls in