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 4418: , mtl_item_revisions mir

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

Line 4426: FROM mtl_item_revisions mir2

4422: AND mir.organization_id = msi.organization_id
4423: AND msi.inventory_item_id = msi.inventory_item_id
4424: AND mir.effectivity_date in
4425: (SELECT MAX(mir2.effectivity_date)
4426: FROM mtl_item_revisions mir2
4427: WHERE mir2.organization_id = get_rcv_transaction_rec.organization_id
4428: AND mir2.inventory_item_id = get_rcv_transaction_rec.item_id
4429: AND mir2.effectivity_date <= SYSDATE
4430: AND mir2.implementation_date is not NULL);

Line 4729: , mtl_item_revisions mir

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

Line 4737: FROM mtl_item_revisions mir2

4733: AND mir.organization_id = msi.organization_id
4734: AND msi.inventory_item_id = msi.inventory_item_id
4735: AND mir.effectivity_date in
4736: (SELECT MAX(mir2.effectivity_date)
4737: FROM mtl_item_revisions mir2
4738: WHERE mir2.organization_id = get_rcv_transaction_asn_rec.organization_id
4739: AND mir2.inventory_item_id = get_rcv_transaction_asn_rec.item_id
4740: AND mir2.effectivity_date <= SYSDATE
4741: AND mir2.implementation_date is not NULL);

Line 4933: , mtl_item_revisions mir

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

Line 4941: FROM mtl_item_revisions mir2

4937: AND mir.organization_id = msi.organization_id
4938: AND msi.inventory_item_id = msi.inventory_item_id
4939: AND mir.effectivity_date in
4940: (SELECT MAX(mir2.effectivity_date)
4941: FROM mtl_item_revisions mir2
4942: WHERE mir2.organization_id = get_rcv_txn_int_req_rec.organization_id
4943: AND mir2.inventory_item_id = get_rcv_txn_int_req_rec.item_id
4944: AND mir2.effectivity_date <= SYSDATE
4945: AND mir2.implementation_date is not NULL);