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 838: FROM MTL_ITEM_REVISIONS_B

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

Line 865: UPDATE MTL_ITEM_REVISIONS_B

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

Line 900: UPDATE MTL_ITEM_REVISIONS_B

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

Line 1022: FROM MTL_ITEM_REVISIONS

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

Line 1061: l_revision mtl_item_revisions_b.revision%TYPE;

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

Line 1087: FROM mtl_item_revisions_b rev, mtl_system_items_b item

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

Line 2007: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE

2003: ERRBUF OUT NOCOPY VARCHAR2
2004: , RETCODE OUT NOCOPY NUMBER
2005: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
2006: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
2007: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
2008: )
2009: IS
2010:
2011: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

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

2009: IS
2010:
2011: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
2012: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
2013: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;
2014:
2015: l_revision_master_controlled VARCHAR2(1);
2016: l_status_master_controlled VARCHAR2(1);
2017: l_is_master_org VARCHAR2(1);

Line 2027: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;

2023:
2024: l_orgs ORG_TABLE;
2025: l_items ITEM_TABLE;
2026: l_revs REV_TABLE;
2027: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
2028: l_master_org MTL_ITEM_REVISIONS_B.ORGANIZATION_ID%TYPE;
2029:
2030: l_ret VARCHAR2(1);
2031: l_error_mesg VARCHAR2(4000);

Line 2028: l_master_org MTL_ITEM_REVISIONS_B.ORGANIZATION_ID%TYPE;

2024: l_orgs ORG_TABLE;
2025: l_items ITEM_TABLE;
2026: l_revs REV_TABLE;
2027: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
2028: l_master_org MTL_ITEM_REVISIONS_B.ORGANIZATION_ID%TYPE;
2029:
2030: l_ret VARCHAR2(1);
2031: l_error_mesg VARCHAR2(4000);
2032:

Line 2119: MTL_ITEM_REVISIONS_B

2115:
2116: SELECT
2117: REVISION BULK COLLECT INTO l_revs
2118: FROM
2119: MTL_ITEM_REVISIONS_B
2120: WHERE ORGANIZATION_ID = l_orgs(org_index)
2121: AND INVENTORY_ITEM_ID = l_items(item_index);
2122:
2123: --If it's all, then also add a null entry to mean no revision

Line 2159: MTL_ITEM_REVISIONS_B

2155:
2156: SELECT
2157: REVISION_ID INTO l_revision_id
2158: FROM
2159: MTL_ITEM_REVISIONS_B
2160: WHERE
2161: ORGANIZATION_ID = l_master_org
2162: AND INVENTORY_ITEM_ID = l_items(item_index)
2163: AND REVISION = l_revs(rev_index);

Line 2170: MTL_ITEM_REVISIONS_B

2166:
2167: SELECT
2168: REVISION_ID INTO l_revision_id
2169: FROM
2170: MTL_ITEM_REVISIONS_B
2171: WHERE
2172: ORGANIZATION_ID = l_orgs(org_index)
2173: AND INVENTORY_ITEM_ID = l_items(item_index)
2174: AND REVISION = l_revs(rev_index);