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.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_PENDING_ITEM_STATUS

Line 496: --If there is a phase change, then insert a record into mtl_pending_item_status

492: ) THEN
493: --
494: -- user is changing lifecycle OR lifecycle phase
495: --
496: --If there is a phase change, then insert a record into mtl_pending_item_status
497: code_debug(l_api_name||': changing the lifecycle now ');
498: l_phase_rec := TRUE;
499: l_pending_flag := 'N';
500: l_implemented_date := l_sysdate;

Line 544: INSERT INTO mtl_pending_item_status(

540:
541: IF (l_status_rec OR l_phase_rec) THEN
542: code_debug(l_api_name||': creating a pending item status ');
543: l_phase_rec := FALSE;
544: INSERT INTO mtl_pending_item_status(
545: inventory_item_id,
546: organization_id,
547: effective_date,
548: implemented_date,

Line 1409: FROM mtl_pending_item_status mpis

1405: ,cp_org_id IN NUMBER
1406: ,cp_rev_id IN NUMBER
1407: ) IS
1408: SELECT organization_id
1409: FROM mtl_pending_item_status mpis
1410: WHERE inventory_item_id = cp_item_id
1411: AND EXISTS
1412: (SELECT P2.ORGANIZATION_ID
1413: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

Line 1675: INSERT INTO mtl_pending_item_status(

1671: END IF;
1672:
1673: l_user_id := FND_GLOBAL.User_Id;
1674: l_sysdate := SYSDATE;
1675: INSERT INTO mtl_pending_item_status(
1676: inventory_item_id,
1677: organization_id,
1678: status_code,
1679: revision_id,