APPS.WMS_ITEM_LOAD dependencies on MTL_TXN_REQUEST_HEADERS

Line 475: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

471: mtrl.uom_code,
472: --laks
473: mtrl.secondary_quantity - NVL(mtrl.secondary_quantity_delivered, 0),
474: mtrl.secondary_uom_code
475: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
476: WHERE mtrl.organization_id = p_organization_id
477: AND mtrl.lpn_id = p_lpn_id
478: AND mtrl.inventory_item_id = p_inventory_item_id
479: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 498: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

494: CURSOR mol_ser_csr_for_inv_rcv IS
495: SELECT mtrl.line_id
496: , Nvl(mtrl.inspection_status,0) inspection_status
497: , quantity-Nvl(quantity_delivered,0) avail_qty
498: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
499: WHERE mtrl.organization_id = p_organization_id
500: AND mtrl.lpn_id = p_lpn_id
501: AND mtrl.inventory_item_id = p_inventory_item_id
502: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 518: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

514:
515: -- Cursor to get the move order lines for WIP serials
516: CURSOR mol_ser_csr_for_wip IS
517: SELECT mtrl.line_id
518: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
519: WHERE mtrl.organization_id = p_organization_id
520: AND mtrl.lpn_id = p_lpn_id
521: AND mtrl.inventory_item_id = p_inventory_item_id
522: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 784: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

780:
781: -- Check if any valid move order lines exist for the item load entry
782: SELECT COUNT(*)
783: INTO l_mo_line_count
784: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
785: WHERE mtrl.organization_id = p_organization_id
786: AND mtrl.lpn_id = p_lpn_id
787: AND mtrl.inventory_item_id = p_inventory_item_id
788: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')