APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 287: FROM mtl_item_revisions_b

283: IF x_revision_id IS NOT NULL THEN
284: BEGIN
285: SELECT revision_id, revision
286: INTO x_revision_id, x_revision
287: FROM mtl_item_revisions_b
288: WHERE inventory_item_id = p_inventory_item_id
289: AND organization_id = p_organization_id
290: AND revision_id = x_revision_id;
291: RETURN TRUE;

Line 305: FROM mtl_item_revisions_b

301: ELSIF x_revision IS NOT NULL THEN
302: BEGIN
303: SELECT revision_id, revision
304: INTO x_revision_id, x_revision
305: FROM mtl_item_revisions_b
306: WHERE inventory_item_id = p_inventory_item_id
307: AND organization_id = p_organization_id
308: AND revision = x_revision;
309: RETURN TRUE;

Line 581: ' MTL_ITEM_REVISIONS_B MIR,'||

577:
578: BEGIN
579: l_policy_check_sql:= 'SELECT ''Y'''||
580: ' FROM MTL_SYSTEM_ITEMS_B MSI,'||
581: ' MTL_ITEM_REVISIONS_B MIR,'||
582: ' ENG_CHANGE_POLICIES_V ECP'||
583: ' WHERE '||
584: ' MSI.INVENTORY_ITEM_ID = :1'||
585: ' AND MSI.ORGANIZATION_ID = :2'||

Line 887: FROM MTL_ITEM_REVISIONS_B

883: -----------------------------------------------------------------------------
884: CURSOR REV_RECORDS_CREATE ( CP_ITEM_ID NUMBER
885: ,CP_ORG_ID NUMBER ) IS
886: SELECT REVISION_ID
887: FROM MTL_ITEM_REVISIONS_B
888: WHERE INVENTORY_ITEM_ID = CP_ITEM_ID
889: AND ORGANIZATION_ID = CP_ORG_ID ;
890: -----------------------------------------------------------------------------
891: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;

Line 909: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;

905: l_org_code_rec c_get_org_code%ROWTYPE;
906: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
907: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
908: ----------------------------------------------------------------
909: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
910: l_cat_tab_index NUMBER := G_MISS_NUM ;
911: l_cat_match VARCHAR2(1) DEFAULT FND_API.G_FALSE ;
912: --Bug: 4881908
913: l_process_control VARCHAR2(2000) := INV_EGO_REVISION_VALIDATE.Get_Process_Control;

Line 1666: FROM MTL_ITEM_REVISIONS_B

1662: ,x_return_status => l_event_return_status);
1663: -------------------------------------------------------------------------
1664: BEGIN
1665: SELECT REVISION_ID INTO l_revision_id_out
1666: FROM MTL_ITEM_REVISIONS_B
1667: WHERE INVENTORY_ITEM_ID = l_Item_rec_out.INVENTORY_ITEM_ID
1668: AND ORGANIZATION_ID = l_Item_rec_in.ORGANIZATION_ID
1669: AND REVISION = l_revision_rec.Revision_Code ;
1670: EXCEPTION

Line 1802: ,mtl_item_revisions_b rev

1798: ,item.description
1799: ,item.organization_id
1800: ,rev.revision_id
1801: FROM mtl_system_items_b_kfv item
1802: ,mtl_item_revisions_b rev
1803: WHERE item.inventory_item_id = cp_item_id
1804: AND item.organization_id = cp_org_id
1805: AND rev.inventory_item_id = cp_item_id
1806: AND rev.organization_id = cp_org_id;

Line 3724: l_revision_id mtl_item_revisions_b.revision_id%TYPE;

3720: l_organization_id mtl_system_items_b.organization_id%TYPE;
3721: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3722: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3723: l_approval_status mtl_system_items_b.approval_status%TYPE;
3724: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
3725: l_revision mtl_item_revisions_b.revision%TYPE;
3726: l_curr_cc_id mtl_system_items_b.item_catalog_group_id%TYPE;
3727: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3728: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;

Line 3725: l_revision mtl_item_revisions_b.revision%TYPE;

3721: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3722: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3723: l_approval_status mtl_system_items_b.approval_status%TYPE;
3724: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
3725: l_revision mtl_item_revisions_b.revision%TYPE;
3726: l_curr_cc_id mtl_system_items_b.item_catalog_group_id%TYPE;
3727: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3728: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3729: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;

Line 3762: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

3758: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER
3759: ,cp_organization_id IN NUMBER
3760: ,cp_revision_id IN NUMBER) IS
3761: SELECT itm.item_catalog_group_id, rev.lifecycle_id, rev.current_phase_id, itm.inventory_item_status_code
3762: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
3763: WHERE itm.inventory_item_id = cp_inventory_item_id
3764: AND itm.organization_id = cp_organization_id
3765: AND rev.inventory_item_id = itm.inventory_item_id
3766: AND rev.organization_id = itm.organization_id --changed = rev.organization_id to itm.organization_id bug 7324207

Line 4388: l_revision_id mtl_item_revisions_b.revision_id%TYPE;

4384: l_organization_id mtl_system_items_b.organization_id%TYPE;
4385: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4386: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4387: l_approval_status mtl_system_items_b.approval_status%TYPE;
4388: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
4389: l_revision mtl_item_revisions_b.revision%TYPE;
4390: l_dummy_char VARCHAR2(999);
4391: l_revision_master_controlled VARCHAR2(1);
4392: l_status_master_controlled VARCHAR2(1);

Line 4389: l_revision mtl_item_revisions_b.revision%TYPE;

4385: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4386: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4387: l_approval_status mtl_system_items_b.approval_status%TYPE;
4388: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
4389: l_revision mtl_item_revisions_b.revision%TYPE;
4390: l_dummy_char VARCHAR2(999);
4391: l_revision_master_controlled VARCHAR2(1);
4392: l_status_master_controlled VARCHAR2(1);
4393: l_is_master_org VARCHAR2(1);