DBA Data[Home] [Help]

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on CSP_EXCESS_LISTS

Line 1120: from csp_excess_lists cel,

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

Line 1154: from csp_excess_lists cel,

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