DBA Data[Home] [Help]

APPS.WIP_VALIDATE dependencies on MTL_DEMAND

Line 1221: FROM mtl_demand

1217: END IF;
1218:
1219: SELECT 'VALID'
1220: INTO l_dummy
1221: FROM mtl_demand
1222: WHERE demand_source_delivery = p_demand_source_delivery
1223: AND demand_source_line = p_demand_source_line
1224: AND demand_source_header_id = p_demand_source_header_id
1225: AND demand_source_type = p_demand_source_type

Line 1271: FROM mtl_demand

1267: END IF;
1268:
1269: SELECT 'VALID'
1270: INTO l_dummy
1271: FROM mtl_demand
1272: WHERE demand_source_header_id = p_demand_source_header_id
1273: AND inventory_item_id = p_inventory_item_id
1274: AND demand_source_type = p_demand_source_type
1275: AND rownum = 1;

Line 1321: FROM mtl_demand

1317: END IF;
1318:
1319: SELECT 'VALID'
1320: INTO l_dummy
1321: FROM mtl_demand
1322: WHERE demand_source_line = p_demand_source_line
1323: AND demand_source_header_id = p_demand_source_header_id
1324: AND demand_source_type = p_demand_source_type
1325: AND inventory_item_id = p_inventory_item_id