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_LIFECYCLE_USER_PUB dependencies on MTL_ITEM_REVISIONS_B

Line 66: FROM mtl_item_revisions_b

62: WHERE inventory_item_id = p_inventory_item_id
63: AND organization_id = p_organization_id
64: AND EXISTS
65: (SELECT revision_id
66: FROM mtl_item_revisions_b
67: WHERE inventory_item_id = p_inventory_item_id
68: AND organization_id = p_organization_id
69: AND revision = p_revision
70: )

Line 759: -- l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;

755: l_api_version NUMBER;
756: l_api_name VARCHAR2(30);
757: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
758: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
759: -- l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
760: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
761: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
762:
763: l_revision_master_controlled VARCHAR2(1);

Line 760: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;

756: l_api_name VARCHAR2(30);
757: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
758: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
759: -- l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
760: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
761: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
762:
763: l_revision_master_controlled VARCHAR2(1);
764: l_status_master_controlled VARCHAR2(1);

Line 761: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;

757: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
758: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
759: -- l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
760: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
761: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
762:
763: l_revision_master_controlled VARCHAR2(1);
764: l_status_master_controlled VARCHAR2(1);
765: l_is_master_org VARCHAR2(1);

Line 798: FROM mtl_item_revisions_b rev

794: OR
795: (revision_id IS NOT NULL
796: AND NOT EXISTS
797: (SELECT 'X'
798: FROM mtl_item_revisions_b rev
799: WHERE rev.inventory_item_id = proj.inventory_item_id
800: AND rev.organization_id = proj.organization_id
801: AND rev.revision_id = proj.revision_id
802: AND rev.lifecycle_id = p_lifecycle_id

Line 1007: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;

1003: l_api_version NUMBER;
1004: l_api_name VARCHAR2(30);
1005: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
1006: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
1007: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1008: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
1009:
1010: l_revision_master_controlled VARCHAR2(1);
1011: l_status_master_controlled VARCHAR2(1);

Line 1008: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;

1004: l_api_name VARCHAR2(30);
1005: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
1006: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
1007: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1008: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
1009:
1010: l_revision_master_controlled VARCHAR2(1);
1011: l_status_master_controlled VARCHAR2(1);
1012: l_is_master_org VARCHAR2(1);

Line 1121: MTL_ITEM_REVISIONS_B

1117: SELECT
1118: --Bug: 2871650 getting Current phase id to compare
1119: REVISION_ID, CURRENT_PHASE_ID INTO l_revision_id, l_current_phase_id
1120: FROM
1121: MTL_ITEM_REVISIONS_B
1122: WHERE
1123: INVENTORY_ITEM_ID = p_inventory_item_id
1124: AND ORGANIZATION_ID = p_organization_id
1125: AND REVISION = p_revision;