DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 4461: FROM mtl_system_items_b msi

4457: BEGIN
4458:
4459: SELECT msi.revision_qty_control_code
4460: INTO l_revision_control_code
4461: FROM mtl_system_items_b msi
4462: WHERE msi.inventory_item_id = get_rcv_transaction_rec.item_id
4463: AND msi.organization_id = get_rcv_transaction_rec.organization_id;
4464:
4465: IF l_revision_control_code = 1 THEN

Line 4760: FROM mtl_system_items_b msi

4756: BEGIN
4757:
4758: SELECT msi.revision_qty_control_code
4759: INTO l_revision_control_code
4760: FROM mtl_system_items_b msi
4761: WHERE msi.inventory_item_id = get_rcv_transaction_asn_rec.item_id
4762: AND msi.organization_id = get_rcv_transaction_asn_rec.organization_id;
4763:
4764: IF l_revision_control_code = 1 THEN

Line 4969: FROM mtl_system_items_b msi

4965: -- item and org from the correct one.
4966: BEGIN
4967: SELECT msi.revision_qty_control_code
4968: INTO l_revision_control_code
4969: FROM mtl_system_items_b msi
4970: WHERE msi.inventory_item_id = get_rcv_txn_int_req_rec.item_id
4971: AND msi.organization_id = get_rcv_txn_int_req_rec.organization_id;
4972:
4973: IF g_debug= C_Debug_Enabled THEN