APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 213: FROM mtl_system_items_b itm, mtl_system_items_b_kfv itm_num

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

Line 232: FROM mtl_system_items_b itm, mtl_system_items_b_kfv itm_num

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

Line 2027: FROM mtl_system_items_b_kfv item

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

Line 3374: FROM mtl_system_items_b_kfv

3370: fnd_message.Set_Token('USER', l_owner_party_name);
3371: IF p_item_number IS NULL THEN
3372: SELECT concatenated_segments
3373: INTO l_dummy_char
3374: FROM mtl_system_items_b_kfv
3375: WHERE organization_id = p_organization_id
3376: AND inventory_item_id = p_inventory_item_id;
3377: ELSE
3378: l_dummy_char := p_item_number;

Line 3450: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

3446: l_end_date DATE;
3447: l_organization_id mtl_system_items_b.organization_id%TYPE;
3448: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3449: l_approval_status mtl_system_items_b.approval_status%TYPE;
3450: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3451: l_hz_party_type hz_parties.party_type%TYPE;
3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3453: l_party_id hz_parties.party_id%TYPE;
3454: l_party_name hz_parties.party_name%TYPE;

Line 3982: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

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

Line 4877: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

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

Line 5105: FROM mtl_system_items_b_kfv

5101:
5102: CURSOR c_itemnum_exists_cursor (cp_item_number IN VARCHAR2
5103: ,cp_organization_id IN NUMBER ) IS
5104: SELECT 'x'
5105: FROM mtl_system_items_b_kfv
5106: WHERE concatenated_segments = cp_item_number
5107: AND organization_id = cp_organization_id;
5108:
5109: BEGIN