APPS.WIP_RESERVATIONS_GRP dependencies on MTL_TXN_REQUEST_LINES

Line 87: FROM mtl_txn_request_lines mtrl,

83: x_source_uom_code := x_source_primary_uom_code ;
84:
85: SELECT NVL(SUM(mtrl.primary_quantity),0)
86: INTO l_crossDock_qty
87: FROM mtl_txn_request_lines mtrl,
88: wms_license_plate_numbers wlpn
89: WHERE mtrl.organization_id = p_organization_id
90: AND mtrl.inventory_item_id = p_item_id
91: AND NVL(mtrl.quantity_delivered, 0) = 0

Line 214: FROM mtl_txn_request_lines mtrl,

210: WDJ.WIP_ENTITY_ID = p_supply_demand_header_id ;
211:
212: SELECT NVL(SUM(mtrl.primary_quantity),0)
213: INTO l_crossDock_qty
214: FROM mtl_txn_request_lines mtrl,
215: wms_license_plate_numbers wlpn
216: WHERE mtrl.organization_id = p_organization_id
217: AND mtrl.inventory_item_id = p_item_id
218: AND NVL(mtrl.quantity_delivered, 0) = 0