DBA Data[Home] [Help]

APPS.WIP_RESERVATIONS_GRP dependencies on WIP_DISCRETE_JOBS

Line 78: FROM WIP_DISCRETE_JOBS WDJ ,

74: MSIK.PRIMARY_UOM_CODE
75: INTO
76: x_available_quantity ,
77: x_source_primary_uom_code
78: FROM WIP_DISCRETE_JOBS WDJ ,
79: MTL_SYSTEM_ITEMS_KFV MSIK
80: WHERE WDJ.WIP_ENTITY_ID = p_supply_demand_header_id
81: AND WDJ.PRIMARY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
82: AND WDJ.ORGANIZATION_ID = MSIK.ORGANIZATION_ID ;

Line 106: FROM WIP_DISCRETE_JOBS WDJ ,

102: MSIK.PRIMARY_UOM_CODE
103: INTO
104: x_available_quantity ,
105: x_source_primary_uom_code
106: FROM WIP_DISCRETE_JOBS WDJ ,
107: MTL_SYSTEM_ITEMS_KFV MSIK
108: WHERE WDJ.WIP_ENTITY_ID = p_supply_demand_header_id
109: AND WDJ.PRIMARY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
110: AND WDJ.ORGANIZATION_ID = MSIK.ORGANIZATION_ID ;

Line 208: FROM WIP_DISCRETE_JOBS WDJ

204: WDJ.STATUS_TYPE
205: INTO
206: -- l_available_qty,
207: l_status_type
208: FROM WIP_DISCRETE_JOBS WDJ
209: WHERE
210: WDJ.WIP_ENTITY_ID = p_supply_demand_header_id ;
211:
212: SELECT NVL(SUM(mtrl.primary_quantity),0)