APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 83: FROM mtl_item_revisions_b

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

Line 168: FROM mtl_item_revisions_b item_rev

164:
165: CURSOR c_get_item_rev_details (cp_item_id IN NUMBER
166: ,cp_org_id IN NUMBER) IS
167: SELECT rowid, revision, revision_id, lifecycle_id, current_phase_id, organization_id
168: FROM mtl_item_revisions_b item_rev
169: WHERE inventory_item_id = cp_item_id
170: AND EXISTS
171: (SELECT P2.ORGANIZATION_ID
172: FROM MTL_PARAMETERS P1,

Line 251: UPDATE mtl_item_revisions_b

247:
248:
249: -- update item revision
250: --
251: UPDATE mtl_item_revisions_b
252: SET lifecycle_id = l_item_rev_lifecycle_id,
253: current_phase_id = l_item_rev_def_phase_id,
254: last_update_date = l_sysdate,
255: last_updated_by = l_user_id,

Line 720: FROM mtl_item_revisions_b

716: SELECT rowid,
717: revision, --3031284
718: lifecycle_id,
719: current_phase_id
720: FROM mtl_item_revisions_b
721: WHERE organization_id = cp_org_id
722: AND inventory_item_id = cp_item_id
723: AND lifecycle_id IS NOT NULL
724: FOR UPDATE OF lifecycle_id,current_phase_id;

Line 990: UPDATE mtl_item_revisions_b

986: l_change := INV_EGO_REVISION_VALIDATE.Check_LifeCycle
987: (p_catalog_group_id => p_new_catalog_group_id
988: ,p_lifecycle_id => revision_record.lifecycle_id);
989: IF NOT l_change THEN
990: UPDATE mtl_item_revisions_b
991: SET lifecycle_id = NULL,
992: current_phase_id = NULL
993: WHERE rowid = revision_record.rowid;
994:

Line 1093: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

1089: ,cp_org_id IN NUMBER
1090: ,cp_rev_id IN NUMBER) IS
1091: SELECT itm.item_catalog_group_id, NVL(rev.lifecycle_id,itm.lifecycle_id) lifecycle_id,
1092: NVL(rev.current_phase_id,itm.current_phase_id) current_phase_id
1093: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
1094: WHERE rev.inventory_item_id = cp_item_id
1095: AND rev.organization_id = cp_org_id
1096: AND rev.revision_id = cp_rev_id
1097: AND itm.inventory_item_id = rev.inventory_item_id

Line 1396: -- FROM mtl_item_revisions_b

1392: AND P2.ORGANIZATION_ID = rev_proj.organization_id
1393: )
1394: -- AND EXISTS
1395: -- (SELECT 'X'
1396: -- FROM mtl_item_revisions_b
1397: -- WHERE revision_id = cp_rev_id
1398: -- AND revision = rev_proj.revision
1399: -- )
1400: AND revision_id = cp_rev_id

Line 1747: FROM mtl_item_revisions_b item_rev

1743:
1744: CURSOR c_get_null_revisions (cp_item_id IN NUMBER
1745: ,cp_org_id IN NUMBER) IS
1746: SELECT inventory_item_id, organization_id, revision_id
1747: FROM mtl_item_revisions_b item_rev
1748: WHERE item_rev.inventory_item_id = cp_item_id
1749: AND EXISTS
1750: (SELECT 'X'
1751: FROM mtl_parameters p1, mtl_parameters p2