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_ITEM_REVISION_PUB dependencies on MTL_PENDING_ITEM_STATUS

Line 1031: INSERT INTO mtl_pending_item_status

1027: --
1028:
1029: IF p_Item_Revision_rec.lifecycle_id IS NOT NULL THEN
1030:
1031: INSERT INTO mtl_pending_item_status
1032: ( Inventory_Item_Id
1033: , Organization_Id
1034: , Status_code
1035: , Effective_date

Line 1735: INSERT INTO mtl_pending_item_status

1731: --
1732: IF l_lifecycle_id IS NOT NULL AND
1733: l_orig_lifecycle_id IS NULL THEN
1734:
1735: INSERT INTO mtl_pending_item_status
1736: ( Inventory_Item_Id
1737: , Organization_Id
1738: , Status_code
1739: , Effective_date

Line 2162: DELETE FROM mtl_pending_item_status

2158:
2159: --
2160: -- Remove the corresponding entries from pending item status table
2161: --
2162: DELETE FROM mtl_pending_item_status
2163: WHERE inventory_item_id = p_inventory_item_id
2164: AND organization_id = p_organization_id
2165: AND revision_id = G_revision_id;
2166: