DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 4545: FROM mtl_system_items_b msi

4541: BEGIN
4542:
4543: SELECT msi.revision_qty_control_code
4544: INTO l_revision_control_code
4545: FROM mtl_system_items_b msi
4546: WHERE msi.inventory_item_id = get_rcv_transaction_rec.item_id
4547: AND msi.organization_id = get_rcv_transaction_rec.organization_id;
4548:
4549: IF l_revision_control_code = 1 THEN

Line 4869: FROM mtl_system_items_b msi

4865: BEGIN
4866:
4867: SELECT msi.revision_qty_control_code
4868: INTO l_revision_control_code
4869: FROM mtl_system_items_b msi
4870: WHERE msi.inventory_item_id = get_rcv_transaction_asn_rec.item_id
4871: AND msi.organization_id = get_rcv_transaction_asn_rec.organization_id;
4872:
4873: IF l_revision_control_code = 1 THEN

Line 5183: FROM mtl_system_items_b msi

5179: -- item and org from the correct one.
5180: BEGIN
5181: SELECT msi.revision_qty_control_code
5182: INTO l_revision_control_code
5183: FROM mtl_system_items_b msi
5184: WHERE msi.inventory_item_id = get_rcv_txn_int_req_rec.item_id
5185: AND msi.organization_id = get_rcv_txn_int_req_rec.organization_id;
5186:
5187: IF g_debug= C_Debug_Enabled THEN