APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_SYSTEM_ITEMS

Line 3652: FROM MTL_SYSTEM_ITEMS

3648: --Bug# 2984835.
3649: CURSOR get_lead_time (v_item_id IN NUMBER
3650: ,v_org_id IN NUMBER) IS
3651: SELECT POSTPROCESSING_LEAD_TIME
3652: FROM MTL_SYSTEM_ITEMS
3653: WHERE INVENTORY_ITEM_ID = v_item_id
3654: AND ORGANIZATION_ID = v_org_id;
3655:
3656: BEGIN

Line 4501: FROM mtl_system_items msi

4497:
4498: BEGIN
4499: SELECT max(mir.revision)
4500: INTO l_item_revision
4501: FROM mtl_system_items msi
4502: , mtl_item_revisions mir
4503: WHERE msi.inventory_item_id = get_rcv_transaction_rec.item_id
4504: AND msi.organization_id = get_rcv_transaction_rec.organization_id
4505: AND msi.revision_qty_control_code = 2

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 4577: from mtl_system_items

4573: --having destination type as shop floor. Modified the code block to include MSI query
4574: BEGIN
4575: select nvl(lot_control_code,1)
4576: into l_lot_control_code
4577: from mtl_system_items
4578: where organization_id = get_rcv_transaction_rec.to_organization_id
4579: and inventory_item_id = get_rcv_transaction_rec.item_id ;
4580:
4581: IF (l_lot_control_code = 2) THEN

Line 4837: FROM mtl_system_items msi

4833:
4834: BEGIN
4835: SELECT max(mir.revision)
4836: INTO l_item_revision
4837: FROM mtl_system_items msi
4838: , mtl_item_revisions mir
4839: WHERE msi.inventory_item_id = get_rcv_transaction_asn_rec.item_id
4840: AND msi.organization_id = get_rcv_transaction_asn_rec.organization_id
4841: AND msi.revision_qty_control_code = 2

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 4897: from mtl_system_items

4893: --having destination type as shop floor. Modified the code block to include MSI query
4894: BEGIN
4895: select nvl(lot_control_code,1)
4896: into l_lot_control_code
4897: from mtl_system_items
4898: where organization_id = get_rcv_transaction_asn_rec.to_organization_id
4899: and inventory_item_id = get_rcv_transaction_asn_rec.item_id ;
4900:
4901: IF (l_lot_control_code = 2) THEN

Line 5146: FROM mtl_system_items msi

5142:
5143: BEGIN
5144: SELECT max(mir.revision)
5145: INTO l_item_revision
5146: FROM mtl_system_items msi
5147: , mtl_item_revisions mir
5148: WHERE msi.inventory_item_id = get_rcv_txn_int_req_rec.item_id
5149: AND msi.organization_id = get_rcv_txn_int_req_rec.organization_id
5150: AND msi.revision_qty_control_code = 2

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

Line 5222: from mtl_system_items

5218: END IF;
5219:
5220: select nvl(lot_control_code,1)
5221: into l_lot_control_code
5222: from mtl_system_items
5223: where organization_id = get_rcv_txn_int_req_rec.to_organization_id
5224: and inventory_item_id = get_rcv_txn_int_req_rec.item_id ;
5225:
5226: IF g_debug= C_Debug_Enabled THEN