APPS.CSP_SUPPLY_DEMAND_PVT dependencies on OE_ORDER_LINES_ALL

Line 1041: from oe_order_lines_all ola,

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

Line 1085: from oe_order_lines_all ola,

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

Line 1186: from oe_order_lines_all ola,

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

Line 1216: from oe_order_lines_all ola,

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