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_ITEM_LC_IMP_PC_PUB dependencies on MTL_ITEM_REVISIONS

Line 271: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

267: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER
268: ,cp_organization_id IN NUMBER
269: ,cp_revision_id IN NUMBER) IS
270: SELECT rev.lifecycle_id, rev.current_phase_id, itm.inventory_item_status_code
271: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
272: WHERE itm.inventory_item_id = cp_inventory_item_id
273: AND itm.organization_id = cp_organization_id
274: AND rev.inventory_item_id = itm.inventory_item_id
275: AND rev.organization_id = rev.organization_id

Line 426: FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_item_revisions_b rev

422:
423: -- bug 3833932
424: CURSOR c_rev_pending_phase_change IS
425: SELECT pending_status.phase_id
426: FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_item_revisions_b rev
427: WHERE pending_status.INVENTORY_ITEM_ID = p_inventory_item_id
428: AND pending_status.ORGANIZATION_ID = p_organization_id
429: AND pending_status.PENDING_FLAG = 'Y'
430: AND pending_status.IMPLEMENTED_DATE IS NULL

Line 465: l_current_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;

461:
462: l_api_version NUMBER;
463: l_api_name VARCHAR2(30);
464: l_current_phase_id MTL_SYSTEM_ITEMS_B.CURRENT_PHASE_ID%TYPE;
465: l_current_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
466: l_perform_policy_check BOOLEAN;
467: l_priv_name_to_check VARCHAR2(100);
468:
469:

Line 836: FROM MTL_ITEM_REVISIONS_B

832: --
833: -- First get the revision code
834: --
835: SELECT REVISION INTO l_current_revision
836: FROM MTL_ITEM_REVISIONS_B
837: WHERE
838: INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
839: AND REVISION_ID = l_pending_record.REVISION_ID
840: AND ORGANIZATION_ID = l_pending_record.ORGANIZATION_ID;

Line 863: UPDATE MTL_ITEM_REVISIONS_B

859: END IF;
860: RETURN;
861: END IF;
862:
863: UPDATE MTL_ITEM_REVISIONS_B
864: SET CURRENT_PHASE_ID = l_pending_record.PHASE_ID
865: WHERE
866: INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
867: AND REVISION = l_current_revision

Line 898: UPDATE MTL_ITEM_REVISIONS_B

894: END IF;
895: RETURN;
896: END IF;
897:
898: UPDATE MTL_ITEM_REVISIONS_B
899: SET CURRENT_PHASE_ID = l_pending_record.PHASE_ID
900: WHERE
901: INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
902: AND REVISION_ID = l_pending_record.REVISION_ID

Line 1020: FROM MTL_ITEM_REVISIONS

1016: BEGIN
1017: l_revision_id := NULL;
1018: SELECT REVISION_ID
1019: INTO l_revision_id
1020: FROM MTL_ITEM_REVISIONS
1021: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1022: AND ORGANIZATION_ID = p_organization_id
1023: AND revision = p_revision;
1024: RETURN l_revision_id;

Line 1059: l_revision mtl_item_revisions_b.revision%TYPE;

1055:
1056: l_api_version NUMBER;
1057: l_api_name VARCHAR2(50);
1058: l_sysdate DATE;
1059: l_revision mtl_item_revisions_b.revision%TYPE;
1060: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1061: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1063: l_status_code mtl_pending_item_status.status_code%TYPE;

Line 1084: FROM mtl_item_revisions_b rev, mtl_system_items_b item

1080: ,cp_org_id IN NUMBER
1081: ,cp_revision IN VARCHAR2
1082: ,cp_revision_id IN NUMBER) IS
1083: SELECT rev.current_phase_id, rev.lifecycle_id, rev.revision, rev.revision_id, item.approval_status
1084: FROM mtl_item_revisions_b rev, mtl_system_items_b item
1085: WHERE rev.inventory_item_id = cp_item_id
1086: AND rev.organization_id = cp_org_id
1087: AND rev.revision = NVL(cp_revision, rev.revision)
1088: AND rev.revision_id = NVL(cp_revision_id, rev.revision_id)

Line 1940: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE

1936: ERRBUF OUT NOCOPY VARCHAR2
1937: , RETCODE OUT NOCOPY NUMBER
1938: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
1939: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
1940: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
1941: )
1942: IS
1943:
1944: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

Line 1946: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;

1942: IS
1943:
1944: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
1945: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
1946: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1947:
1948: l_revision_master_controlled VARCHAR2(1);
1949: l_status_master_controlled VARCHAR2(1);
1950: l_is_master_org VARCHAR2(1);

Line 1960: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;

1956:
1957: l_orgs ORG_TABLE;
1958: l_items ITEM_TABLE;
1959: l_revs REV_TABLE;
1960: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1961: l_master_org MTL_ITEM_REVISIONS_B.ORGANIZATION_ID%TYPE;
1962:
1963: l_ret VARCHAR2(1);
1964: l_error_mesg VARCHAR2(4000);

Line 1961: l_master_org MTL_ITEM_REVISIONS_B.ORGANIZATION_ID%TYPE;

1957: l_orgs ORG_TABLE;
1958: l_items ITEM_TABLE;
1959: l_revs REV_TABLE;
1960: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1961: l_master_org MTL_ITEM_REVISIONS_B.ORGANIZATION_ID%TYPE;
1962:
1963: l_ret VARCHAR2(1);
1964: l_error_mesg VARCHAR2(4000);
1965:

Line 2052: MTL_ITEM_REVISIONS_B

2048:
2049: SELECT
2050: REVISION BULK COLLECT INTO l_revs
2051: FROM
2052: MTL_ITEM_REVISIONS_B
2053: WHERE ORGANIZATION_ID = l_orgs(org_index)
2054: AND INVENTORY_ITEM_ID = l_items(item_index);
2055:
2056: --If it's all, then also add a null entry to mean no revision

Line 2092: MTL_ITEM_REVISIONS_B

2088:
2089: SELECT
2090: REVISION_ID INTO l_revision_id
2091: FROM
2092: MTL_ITEM_REVISIONS_B
2093: WHERE
2094: ORGANIZATION_ID = l_master_org
2095: AND INVENTORY_ITEM_ID = l_items(item_index)
2096: AND REVISION = l_revs(rev_index);

Line 2103: MTL_ITEM_REVISIONS_B

2099:
2100: SELECT
2101: REVISION_ID INTO l_revision_id
2102: FROM
2103: MTL_ITEM_REVISIONS_B
2104: WHERE
2105: ORGANIZATION_ID = l_orgs(org_index)
2106: AND INVENTORY_ITEM_ID = l_items(item_index)
2107: AND REVISION = l_revs(rev_index);