DBA Data[Home] [Help]

APPS.INV_CONSIGNED_VALIDATIONS dependencies on MTL_TRANSACTION_TYPES

Line 2725: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, mtl_transaction_types mtt

2721: ,mtrl.uom_code
2722: ,mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2723: )
2724: INTO l_lpn_qty
2725: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, mtl_transaction_types mtt
2726: where mtrl.organization_id = p_org_id
2727: AND mtrl.inventory_item_id = p_item_id
2728: AND mtrl.header_id = mtrh.header_id
2729: AND mtrh.move_order_type = 6 -- Putaway Move Order

Line 3589: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, mtl_transaction_types mtt

3585: ,mtrl.uom_code
3586: ,mtrl.quantity - NVL(mtrl.quantity_delivered,0))
3587: )
3588: INTO l_lpn_qty
3589: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, mtl_transaction_types mtt
3590: where mtrl.organization_id = p_org_id
3591: AND mtrl.inventory_item_id = p_item_id
3592: AND mtrl.header_id = mtrh.header_id
3593: AND mtrh.move_order_type = 6 -- Putaway Move Order