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 1086: INSERT INTO mtl_pending_item_status

1082: --
1083:
1084: IF p_Item_Revision_rec.lifecycle_id IS NOT NULL THEN
1085:
1086: INSERT INTO mtl_pending_item_status
1087: ( Inventory_Item_Id
1088: , Organization_Id
1089: , Status_code
1090: , Effective_date

Line 1797: INSERT INTO mtl_pending_item_status

1793: --
1794: IF l_lifecycle_id IS NOT NULL AND
1795: l_orig_lifecycle_id IS NULL THEN
1796:
1797: INSERT INTO mtl_pending_item_status
1798: ( Inventory_Item_Id
1799: , Organization_Id
1800: , Status_code
1801: , Effective_date

Line 2224: DELETE FROM mtl_pending_item_status

2220:
2221: --
2222: -- Remove the corresponding entries from pending item status table
2223: --
2224: DELETE FROM mtl_pending_item_status
2225: WHERE inventory_item_id = p_inventory_item_id
2226: AND organization_id = p_organization_id
2227: AND revision_id = G_revision_id;
2228: