DBA Data[Home] [Help]

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on CSP_EXCESS_LISTS

Line 1121: from csp_excess_lists cel,

1117: cel.subinventory_code,
1118: cpp.planning_parameters_id,
1119: cpp.level_id,
1120: sum(nvl(excess_quantity,0))
1121: from csp_excess_lists cel,
1122: csp_sec_inventories csi,
1123: csp_planning_parameters cpp
1124: where cel.condition_code = 'G'
1125: and cel.excess_status = 'O'

Line 1155: from csp_excess_lists cel,

1151: cel.organization_id,
1152: cpp.planning_parameters_id,
1153: cpp.level_id,
1154: sum(cel.excess_quantity)
1155: from csp_excess_lists cel,
1156: csp_planning_parameters cpp
1157: where cel.condition_code = 'G'
1158: and cel.excess_status = 'O'
1159: and cel.subinventory_code is null