APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 209: FROM mtl_system_items_b itm, mtl_system_items_b_kfv itm_num

205: IF x_inventory_item_id IS NOT NULL THEN
206: BEGIN
207: SELECT itm.inventory_item_id, itm.approval_status, itm_num.concatenated_segments
208: INTO x_inventory_item_id, x_approval_status, x_item_number
209: FROM mtl_system_items_b itm, mtl_system_items_b_kfv itm_num
210: WHERE itm.inventory_item_id = x_inventory_item_id
211: AND itm.organization_id = p_organization_id
212: AND itm_num.inventory_item_id = itm.inventory_item_id
213: AND itm_num.organization_id = itm.organization_id;

Line 228: FROM mtl_system_items_b itm, mtl_system_items_b_kfv itm_num

224: ELSIF x_item_number IS NOT NULL THEN
225: BEGIN
226: SELECT itm.inventory_item_id, itm.approval_status, itm_num.concatenated_segments
227: INTO x_inventory_item_id, x_approval_status, x_item_number
228: FROM mtl_system_items_b itm, mtl_system_items_b_kfv itm_num
229: WHERE itm_num.organization_id = p_organization_id
230: AND itm_num.concatenated_segments = x_item_number
231: AND itm.inventory_item_id = itm_num.inventory_item_id
232: AND itm.organization_id = itm_num.organization_id;

Line 1801: FROM mtl_system_items_b_kfv item

1797: SELECT item.concatenated_segments
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

Line 3114: FROM mtl_system_items_b_kfv

3110: fnd_message.Set_Token('USER', l_owner_party_name);
3111: IF p_item_number IS NULL THEN
3112: SELECT concatenated_segments
3113: INTO l_dummy_char
3114: FROM mtl_system_items_b_kfv
3115: WHERE organization_id = p_organization_id
3116: AND inventory_item_id = p_inventory_item_id;
3117: ELSE
3118: l_dummy_char := p_item_number;

Line 3190: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

3186: l_end_date DATE;
3187: l_organization_id mtl_system_items_b.organization_id%TYPE;
3188: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3189: l_approval_status mtl_system_items_b.approval_status%TYPE;
3190: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3191: l_hz_party_type hz_parties.party_type%TYPE;
3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3193: l_party_id hz_parties.party_id%TYPE;
3194: l_party_name hz_parties.party_name%TYPE;

Line 3722: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

3718: l_api_name VARCHAR2(30);
3719: l_api_version NUMBER;
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;

Line 4386: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

4382: l_api_name VARCHAR2(30);
4383: l_api_version NUMBER;
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);

Line 4614: FROM mtl_system_items_b_kfv

4610:
4611: CURSOR c_itemnum_exists_cursor (cp_item_number IN VARCHAR2
4612: ,cp_organization_id IN NUMBER ) IS
4613: SELECT 'x'
4614: FROM mtl_system_items_b_kfv
4615: WHERE concatenated_segments = cp_item_number
4616: AND organization_id = cp_organization_id;
4617:
4618: BEGIN