APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 82: FROM mtl_item_revisions_b

78: -- get revision name
79: --
80: SELECT revision
81: INTO l_revision
82: FROM mtl_item_revisions_b
83: WHERE revision_id = p_item_revision_id;
84: fnd_message.set_token('REVISION', l_revision);
85: ELSE
86: fnd_message.set_name('EGO', p_message_name);

Line 154: FROM mtl_item_revisions_b item_rev

150:
151: CURSOR c_get_item_rev_details (cp_item_id IN NUMBER
152: ,cp_org_id IN NUMBER) IS
153: SELECT rowid, revision, revision_id, lifecycle_id, current_phase_id, organization_id
154: FROM mtl_item_revisions_b item_rev
155: WHERE inventory_item_id = cp_item_id
156: AND EXISTS
157: (SELECT P2.ORGANIZATION_ID
158: FROM MTL_PARAMETERS P1,

Line 237: UPDATE mtl_item_revisions_b

233:
234:
235: -- update item revision
236: --
237: UPDATE mtl_item_revisions_b
238: SET lifecycle_id = l_item_rev_lifecycle_id,
239: current_phase_id = l_item_rev_def_phase_id,
240: last_update_date = l_sysdate,
241: last_updated_by = l_user_id,

Line 694: FROM mtl_item_revisions_b

690: SELECT rowid,
691: revision, --3031284
692: lifecycle_id,
693: current_phase_id
694: FROM mtl_item_revisions_b
695: WHERE organization_id = cp_org_id
696: AND inventory_item_id = cp_item_id
697: AND lifecycle_id IS NOT NULL
698: FOR UPDATE OF lifecycle_id,current_phase_id;

Line 923: UPDATE mtl_item_revisions_b

919: l_change := INV_EGO_REVISION_VALIDATE.Check_LifeCycle
920: (p_catalog_group_id => p_new_catalog_group_id
921: ,p_lifecycle_id => revision_record.lifecycle_id);
922: IF NOT l_change THEN
923: UPDATE mtl_item_revisions_b
924: SET lifecycle_id = NULL,
925: current_phase_id = NULL
926: WHERE rowid = revision_record.rowid;
927:

Line 1026: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

1022: ,cp_org_id IN NUMBER
1023: ,cp_rev_id IN NUMBER) IS
1024: SELECT itm.item_catalog_group_id, NVL(rev.lifecycle_id,itm.lifecycle_id) lifecycle_id,
1025: NVL(rev.current_phase_id,itm.current_phase_id) current_phase_id
1026: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
1027: WHERE rev.inventory_item_id = cp_item_id
1028: AND rev.organization_id = cp_org_id
1029: AND rev.revision_id = cp_rev_id
1030: AND itm.inventory_item_id = rev.inventory_item_id

Line 1326: -- FROM mtl_item_revisions_b

1322: AND P2.ORGANIZATION_ID = rev_proj.organization_id
1323: )
1324: -- AND EXISTS
1325: -- (SELECT 'X'
1326: -- FROM mtl_item_revisions_b
1327: -- WHERE revision_id = cp_rev_id
1328: -- AND revision = rev_proj.revision
1329: -- )
1330: AND revision_id = cp_rev_id

Line 1674: FROM mtl_item_revisions_b item_rev

1670:
1671: CURSOR c_get_null_revisions (cp_item_id IN NUMBER
1672: ,cp_org_id IN NUMBER) IS
1673: SELECT inventory_item_id, organization_id, revision_id
1674: FROM mtl_item_revisions_b item_rev
1675: WHERE item_rev.inventory_item_id = cp_item_id
1676: AND EXISTS
1677: (SELECT 'X'
1678: FROM mtl_parameters p1, mtl_parameters p2