eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on MTL_ITEM_REVISIONS

Line 4502: , mtl_item_revisions mir

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
4506: AND mir.organization_id = msi.organization_id

Line 4510: FROM mtl_item_revisions mir2

4506: AND mir.organization_id = msi.organization_id
4507: AND mir.inventory_item_id = msi.inventory_item_id --Bug# 10365814
4508: AND mir.effectivity_date in
4509: (SELECT MAX(mir2.effectivity_date)
4510: FROM mtl_item_revisions mir2
4511: WHERE mir2.organization_id = get_rcv_transaction_rec.organization_id
4512: AND mir2.inventory_item_id = get_rcv_transaction_rec.item_id
4513: AND mir2.effectivity_date <= SYSDATE
4514: AND mir2.implementation_date is not NULL);

Line 4838: , mtl_item_revisions mir

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
4842: AND mir.organization_id = msi.organization_id

Line 4846: FROM mtl_item_revisions mir2

4842: AND mir.organization_id = msi.organization_id
4843: AND mir.inventory_item_id = msi.inventory_item_id --Bug# 10365814
4844: AND mir.effectivity_date in
4845: (SELECT MAX(mir2.effectivity_date)
4846: FROM mtl_item_revisions mir2
4847: WHERE mir2.organization_id = get_rcv_transaction_asn_rec.organization_id
4848: AND mir2.inventory_item_id = get_rcv_transaction_asn_rec.item_id
4849: AND mir2.effectivity_date <= SYSDATE
4850: AND mir2.implementation_date is not NULL);

Line 5147: , mtl_item_revisions mir

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
5151: AND mir.organization_id = msi.organization_id

Line 5155: FROM mtl_item_revisions mir2

5151: AND mir.organization_id = msi.organization_id
5152: AND mir.inventory_item_id = msi.inventory_item_id --Bug# 10365814
5153: AND mir.effectivity_date in
5154: (SELECT MAX(mir2.effectivity_date)
5155: FROM mtl_item_revisions mir2
5156: WHERE mir2.organization_id = get_rcv_txn_int_req_rec.organization_id
5157: AND mir2.inventory_item_id = get_rcv_txn_int_req_rec.item_id
5158: AND mir2.effectivity_date <= SYSDATE
5159: AND mir2.implementation_date is not NULL);