DBA Data[Home] [Help]

APPS.WIP_RESERVATIONS_GRP dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 88: wms_license_plate_numbers wlpn

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
92: AND mtrl.txn_source_id = p_supply_demand_header_id

Line 215: wms_license_plate_numbers wlpn

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
219: AND mtrl.txn_source_id = p_supply_demand_header_id