APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_SYSTEM_ITEMS

Line 3638: FROM MTL_SYSTEM_ITEMS

3634: --Bug# 2984835.
3635: CURSOR get_lead_time (v_item_id IN NUMBER
3636: ,v_org_id IN NUMBER) IS
3637: SELECT POSTPROCESSING_LEAD_TIME
3638: FROM MTL_SYSTEM_ITEMS
3639: WHERE INVENTORY_ITEM_ID = v_item_id
3640: AND ORGANIZATION_ID = v_org_id;
3641:
3642: BEGIN

Line 4417: FROM mtl_system_items msi

4413:
4414: BEGIN
4415: SELECT max(mir.revision)
4416: INTO l_item_revision
4417: FROM mtl_system_items msi
4418: , mtl_item_revisions mir
4419: WHERE msi.inventory_item_id = get_rcv_transaction_rec.item_id
4420: AND msi.organization_id = get_rcv_transaction_rec.organization_id
4421: AND msi.revision_qty_control_code = 2

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

4489: --having destination type as shop floor. Modified the code block to include MSI query
4490: BEGIN
4491: select nvl(lot_control_code,1)
4492: into l_lot_control_code
4493: from mtl_system_items
4494: where organization_id = get_rcv_transaction_rec.to_organization_id
4495: and inventory_item_id = get_rcv_transaction_rec.item_id ;
4496:
4497: IF (l_lot_control_code = 2) THEN

Line 4728: FROM mtl_system_items msi

4724:
4725: BEGIN
4726: SELECT max(mir.revision)
4727: INTO l_item_revision
4728: FROM mtl_system_items msi
4729: , mtl_item_revisions mir
4730: WHERE msi.inventory_item_id = get_rcv_transaction_asn_rec.item_id
4731: AND msi.organization_id = get_rcv_transaction_asn_rec.organization_id
4732: AND msi.revision_qty_control_code = 2

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

4784: --having destination type as shop floor. Modified the code block to include MSI query
4785: BEGIN
4786: select nvl(lot_control_code,1)
4787: into l_lot_control_code
4788: from mtl_system_items
4789: where organization_id = get_rcv_transaction_rec.to_organization_id
4790: and inventory_item_id = get_rcv_transaction_rec.item_id ;
4791:
4792: IF (l_lot_control_code = 2) THEN

Line 4932: FROM mtl_system_items msi

4928:
4929: BEGIN
4930: SELECT max(mir.revision)
4931: INTO l_item_revision
4932: FROM mtl_system_items msi
4933: , mtl_item_revisions mir
4934: WHERE msi.inventory_item_id = get_rcv_txn_int_req_rec.item_id
4935: AND msi.organization_id = get_rcv_txn_int_req_rec.organization_id
4936: AND msi.revision_qty_control_code = 2

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

Line 5002: from mtl_system_items

4998: --having destination type as shop floor. Modified the code block to include MSI query
4999: BEGIN
5000: select nvl(lot_control_code,1)
5001: into l_lot_control_code
5002: from mtl_system_items
5003: where organization_id = get_rcv_transaction_rec.to_organization_id
5004: and inventory_item_id = get_rcv_transaction_rec.item_id ;
5005:
5006: IF (l_lot_control_code = 2) THEN