APPS.CSP_SUPPLY_DEMAND_PVT dependencies on OE_ORDER_LINES_ALL

Line 1042: from oe_order_lines_all ola,

1038: decode(ola.order_source_id,10,
1039: sum(nvl(ola.ordered_quantity,0) -
1040: nvl(ola.cancelled_quantity,0) -
1041: nvl(ola.shipped_quantity,0)),0) internal_orders_out
1042: from oe_order_lines_all ola,
1043: csp_sec_inventories csi,
1044: csp_planning_parameters cpp
1045: where ola.ship_from_org_id = csi.organization_id
1046: and ola.subinventory = csi.secondary_inventory_name

Line 1086: from oe_order_lines_all ola,

1082: decode(ola.order_source_id,10,
1083: sum(nvl(ola.ordered_quantity,0) -
1084: nvl(ola.cancelled_quantity,0) -
1085: nvl(ola.shipped_quantity,0)),0) internal_orders_out
1086: from oe_order_lines_all ola,
1087: csp_planning_parameters cpp
1088: where ola.ship_from_org_id = cpp.organization_id
1089: and ola.subinventory = cpp.secondary_inventory
1090: and ola.open_flag = 'Y'

Line 1187: from oe_order_lines_all ola,

1183: cpp.level_id,
1184: sum(nvl(ola.ordered_quantity,0) -
1185: nvl(ola.cancelled_quantity,0) -
1186: nvl(ola.shipped_quantity,0))
1187: from oe_order_lines_all ola,
1188: csp_planning_parameters cpp
1189: where ola.ship_from_org_id = cpp.organization_id
1190: and cpp.organization_type = 'W'
1191: and ola.open_flag = 'Y'

Line 1217: from oe_order_lines_all ola,

1213: cpp.level_id,
1214: sum(nvl(ola.ordered_quantity,0) -
1215: nvl(ola.cancelled_quantity,0) -
1216: nvl(ola.shipped_quantity,0))
1217: from oe_order_lines_all ola,
1218: csp_planning_parameters cpp
1219: where ola.ship_from_org_id = cpp.organization_id
1220: and cpp.organization_type = 'W'
1221: and cpp.node_type = 'ORGANIZATION_WH'