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

Line 291: FROM mtl_item_revisions_b

287: IF x_revision_id IS NOT NULL THEN
288: BEGIN
289: SELECT revision_id, revision
290: INTO x_revision_id, x_revision
291: FROM mtl_item_revisions_b
292: WHERE inventory_item_id = p_inventory_item_id
293: AND organization_id = p_organization_id
294: AND revision_id = x_revision_id;
295: RETURN TRUE;

Line 309: FROM mtl_item_revisions_b

305: ELSIF x_revision IS NOT NULL THEN
306: BEGIN
307: SELECT revision_id, revision
308: INTO x_revision_id, x_revision
309: FROM mtl_item_revisions_b
310: WHERE inventory_item_id = p_inventory_item_id
311: AND organization_id = p_organization_id
312: AND revision = x_revision;
313: RETURN TRUE;

Line 585: ' MTL_ITEM_REVISIONS_B MIR,'||

581:
582: BEGIN
583: l_policy_check_sql:= 'SELECT ''Y'''||
584: ' FROM MTL_SYSTEM_ITEMS_B MSI,'||
585: ' MTL_ITEM_REVISIONS_B MIR,'||
586: ' ENG_CHANGE_POLICIES_V ECP'||
587: ' WHERE '||
588: ' MSI.INVENTORY_ITEM_ID = :1'||
589: ' AND MSI.ORGANIZATION_ID = :2'||

Line 1083: FROM MTL_ITEM_REVISIONS_B

1079: -----------------------------------------------------------------------------
1080: CURSOR REV_RECORDS_CREATE ( CP_ITEM_ID NUMBER
1081: ,CP_ORG_ID NUMBER ) IS
1082: SELECT REVISION_ID
1083: FROM MTL_ITEM_REVISIONS_B
1084: WHERE INVENTORY_ITEM_ID = CP_ITEM_ID
1085: AND ORGANIZATION_ID = CP_ORG_ID ;
1086: -----------------------------------------------------------------------------
1087: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;

Line 1105: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;

1101: l_org_code_rec c_get_org_code%ROWTYPE;
1102: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
1103: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
1104: ----------------------------------------------------------------
1105: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1106: l_cat_tab_index NUMBER := G_MISS_NUM ;
1107: l_cat_match VARCHAR2(1) DEFAULT FND_API.G_FALSE ;
1108: --Bug: 4881908
1109: l_process_control VARCHAR2(2000) := INV_EGO_REVISION_VALIDATE.Get_Process_Control;

Line 1892: FROM MTL_ITEM_REVISIONS_B

1888: ,x_return_status => l_event_return_status);
1889: -------------------------------------------------------------------------
1890: BEGIN
1891: SELECT REVISION_ID INTO l_revision_id_out
1892: FROM MTL_ITEM_REVISIONS_B
1893: WHERE INVENTORY_ITEM_ID = l_Item_rec_out.INVENTORY_ITEM_ID
1894: AND ORGANIZATION_ID = l_Item_rec_out.ORGANIZATION_ID
1895: AND REVISION = l_revision_rec.Revision_Code ;
1896: EXCEPTION

Line 2028: ,mtl_item_revisions_b rev

2024: ,item.description
2025: ,item.organization_id
2026: ,rev.revision_id
2027: FROM mtl_system_items_b_kfv item
2028: ,mtl_item_revisions_b rev
2029: WHERE item.inventory_item_id = cp_item_id
2030: AND item.organization_id = cp_org_id
2031: AND rev.inventory_item_id = cp_item_id
2032: AND rev.organization_id = cp_org_id;

Line 3984: l_revision_id mtl_item_revisions_b.revision_id%TYPE;

3980: l_organization_id mtl_system_items_b.organization_id%TYPE;
3981: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3982: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3983: l_approval_status mtl_system_items_b.approval_status%TYPE;
3984: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
3985: l_revision mtl_item_revisions_b.revision%TYPE;
3986: l_curr_cc_id mtl_system_items_b.item_catalog_group_id%TYPE;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;

Line 3985: l_revision mtl_item_revisions_b.revision%TYPE;

3981: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3982: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3983: l_approval_status mtl_system_items_b.approval_status%TYPE;
3984: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
3985: l_revision mtl_item_revisions_b.revision%TYPE;
3986: l_curr_cc_id mtl_system_items_b.item_catalog_group_id%TYPE;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3989: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;

Line 4023: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

4019: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER
4020: ,cp_organization_id IN NUMBER
4021: ,cp_revision_id IN NUMBER) IS
4022: SELECT itm.item_catalog_group_id, rev.lifecycle_id, rev.current_phase_id, itm.inventory_item_status_code
4023: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
4024: WHERE itm.inventory_item_id = cp_inventory_item_id
4025: AND itm.organization_id = cp_organization_id
4026: AND rev.inventory_item_id = itm.inventory_item_id
4027: AND rev.organization_id = itm.organization_id --changed = rev.organization_id to itm.organization_id bug 7324207

Line 4879: l_revision_id mtl_item_revisions_b.revision_id%TYPE;

4875: l_organization_id mtl_system_items_b.organization_id%TYPE;
4876: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4877: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4878: l_approval_status mtl_system_items_b.approval_status%TYPE;
4879: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
4880: l_revision mtl_item_revisions_b.revision%TYPE;
4881: l_dummy_char VARCHAR2(999);
4882: l_revision_master_controlled VARCHAR2(1);
4883: l_status_master_controlled VARCHAR2(1);

Line 4880: l_revision mtl_item_revisions_b.revision%TYPE;

4876: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4877: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4878: l_approval_status mtl_system_items_b.approval_status%TYPE;
4879: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
4880: l_revision mtl_item_revisions_b.revision%TYPE;
4881: l_dummy_char VARCHAR2(999);
4882: l_revision_master_controlled VARCHAR2(1);
4883: l_status_master_controlled VARCHAR2(1);
4884: l_is_master_org VARCHAR2(1);