eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_B

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 584: ' FROM MTL_SYSTEM_ITEMS_B MSI,'||

580: l_policy_check_sql VARCHAR2(32767);
581:
582: BEGIN
583: l_policy_check_sql:= 'SELECT ''Y'''||
584: ' FROM MTL_SYSTEM_ITEMS_B MSI,'||
585: ' MTL_ITEM_REVISIONS_B MIR,'||
586: ' ENG_CHANGE_POLICIES_V ECP'||
587: ' WHERE '||
588: ' MSI.INVENTORY_ITEM_ID = :1'||

Line 677: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;

673: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
674: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;
675: l_policy_cat_id NUMBER;
676: l_catalog_category_names_table LOCAL_MEDIUM_VARCHAR_TABLE;
677: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
678: l_row_identifier NUMBER;
679: i NUMBER :=0;
680: BEGIN
681: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

Line 704: SELECT segment1 INTO l_item_number FROM MTL_SYSTEM_ITEMS_B WHERE inventory_item_id=p_inventory_item_id;

700:
701: l_token_table(1).TOKEN_NAME := 'ATTR_GROUP_NAME';
702: l_token_table(1).TOKEN_VALUE := l_current_data_element.ATTR_GROUP_NAME;
703:
704: SELECT segment1 INTO l_item_number FROM MTL_SYSTEM_ITEMS_B WHERE inventory_item_id=p_inventory_item_id;
705:
706:
707: l_token_table(2).TOKEN_NAME := 'ITEM_NUMBER';
708: l_token_table(2).TOKEN_VALUE := l_item_number;

Line 712: FROM MTL_SYSTEM_ITEMS_B MSI

708: l_token_table(2).TOKEN_VALUE := l_item_number;
709:
710: SELECT PEP.NAME
711: INTO l_current_life_cycle
712: FROM MTL_SYSTEM_ITEMS_B MSI
713: ,PA_EGO_LIFECYCLES_V PEP
714: WHERE MSI.INVENTORY_ITEM_ID =p_inventory_item_id
715: AND MSI.ORGANIZATION_ID = p_organization_id
716: AND MSI.LIFECYCLE_ID = PEP.PROJ_ELEMENT_ID;

Line 723: FROM MTL_SYSTEM_ITEMS_B MSI

719: l_token_table(3).TOKEN_VALUE := l_current_life_cycle;
720:
721: SELECT PEP.NAME
722: INTO l_current_phase_name
723: FROM MTL_SYSTEM_ITEMS_B MSI
724: ,PA_EGO_PHASES_V PEP
725: WHERE MSI.INVENTORY_ITEM_ID = p_inventory_item_id
726: AND MSI.ORGANIZATION_ID = p_organization_id
727: AND MSI.CURRENT_PHASE_ID = PEP.PROJ_ELEMENT_ID;

Line 738: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI

734: FROM (SELECT item_catalog_group_id
735: FROM mtl_item_catalog_groups_b ic
736: WHERE EXISTS
737: ( SELECT olc.object_classification_code CatalogId
738: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI
739: WHERE olc.object_id = l_object_id
740: AND olc.lifecycle_id = MSI.lifecycle_id
741: AND MSI.inventory_item_id = p_inventory_item_id
742: AND MSI.organization_id = p_organization_id

Line 748: FROM MTL_SYSTEM_ITEMS_B

744: )
745: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
746: START WITH item_catalog_group_id
747: =(SELECT item_catalog_group_id
748: FROM MTL_SYSTEM_ITEMS_B
749: WHERE inventory_item_id=p_inventory_item_id
750: )
751: ) CAT_HIER
752: WHERE ROWNUM = 1;

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 2043: l_master_org MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
2040: l_rev_index_failure BOOLEAN := FALSE;
2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
2042: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
2043: l_master_org MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
2044: l_event_return_status VARCHAR2(1) ; --business event enhancement
2045: l_item_rev_rec c_get_item_rev_rec%ROWTYPE;
2046: l_msg_data VARCHAR2(2000);
2047: l_process_control VARCHAR2(2000) := INV_EGO_REVISION_VALIDATE.Get_Process_Control; --Bug: 4881908

Line 2778: FROM MTL_SYSTEM_ITEMS_B

2774: -- Bug: 5636895 added NVL(ITEM...., -1)
2775: BEGIN
2776: SELECT NVL(ITEM_CATALOG_GROUP_ID, -1)
2777: INTO l_item_catalog_group_id
2778: FROM MTL_SYSTEM_ITEMS_B
2779: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2780: AND ORGANIZATION_ID = p_organization_id;
2781: EXCEPTION
2782: WHEN NO_DATA_FOUND THEN

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 3447: l_organization_id mtl_system_items_b.organization_id%TYPE;

3443: l_dummy_char VARCHAR2(32767);
3444: l_sysdate DATE;
3445: l_start_date DATE;
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;

Line 3448: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

3444: l_sysdate DATE;
3445: l_start_date DATE;
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;

Line 3449: l_approval_status mtl_system_items_b.approval_status%TYPE;

3445: l_start_date DATE;
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;

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 3980: l_organization_id mtl_system_items_b.organization_id%TYPE;

3976: ,x_msg_data OUT NOCOPY VARCHAR2
3977: ) IS
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;

Line 3981: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

3977: ) IS
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;

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 3983: l_approval_status mtl_system_items_b.approval_status%TYPE;

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;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;

Line 3986: l_curr_cc_id mtl_system_items_b.item_catalog_group_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;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3989: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;
3990: l_item_sequence NUMBER;

Line 3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%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;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3989: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;
3990: l_item_sequence NUMBER;
3991: l_phase_sequence NUMBER;

Line 3988: l_curr_phase_id mtl_system_items_b.current_phase_id%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;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3989: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;
3990: l_item_sequence NUMBER;
3991: l_phase_sequence NUMBER;
3992: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;

Line 3989: l_future_phase_id mtl_system_items_b.current_phase_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;
3987: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%TYPE;
3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3989: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;
3990: l_item_sequence NUMBER;
3991: l_phase_sequence NUMBER;
3992: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;
3993: l_policy_code VARCHAR2(99);

Line 3992: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;

3988: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
3989: l_future_phase_id mtl_system_items_b.current_phase_id%TYPE;
3990: l_item_sequence NUMBER;
3991: l_phase_sequence NUMBER;
3992: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;
3993: l_policy_code VARCHAR2(99);
3994: l_policy_co_required VARCHAR2(99);
3995: l_policy_not_allowed VARCHAR2(99);
3996: l_sysdate DATE;

Line 4015: FROM mtl_system_items_b

4011: CURSOR c_get_item_det (cp_inventory_item_id IN NUMBER
4012: ,cp_organization_id IN NUMBER) IS
4013: SELECT item_catalog_group_id, lifecycle_id,
4014: current_phase_id, inventory_item_status_code
4015: FROM mtl_system_items_b
4016: WHERE inventory_item_id = cp_inventory_item_id
4017: AND organization_id = cp_organization_id;
4018:
4019: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER

Line 4023: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

4019: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER
4020: ,cp_organization_id IN NUMBER
4021: ,cp_revision_id IN NUMBER) IS
4022: SELECT itm.item_catalog_group_id, rev.lifecycle_id, rev.current_phase_id, itm.inventory_item_status_code
4023: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
4024: WHERE itm.inventory_item_id = cp_inventory_item_id
4025: AND itm.organization_id = cp_organization_id
4026: AND rev.inventory_item_id = itm.inventory_item_id
4027: AND rev.organization_id = itm.organization_id --changed = rev.organization_id to itm.organization_id bug 7324207

Line 4875: l_organization_id mtl_system_items_b.organization_id%TYPE;

4871: ,x_msg_data OUT NOCOPY VARCHAR2
4872: ) IS
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;

Line 4876: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

4872: ) IS
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;

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 4878: l_approval_status mtl_system_items_b.approval_status%TYPE;

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);
4882: l_revision_master_controlled VARCHAR2(1);

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

Line 5341: FROM MTL_SYSTEM_ITEMS_B

5337:
5338: CURSOR get_catalog_group_id IS
5339: SELECT ITEM_CATALOG_GROUP_ID
5340: INTO l_item_catalog_group_id
5341: FROM MTL_SYSTEM_ITEMS_B
5342: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
5343: AND ORGANIZATION_ID = p_organization_id;
5344:
5345: BEGIN

Line 6322: from mtl_system_items_b

6318:
6319: BEGIN
6320: select 'x'
6321: into l_validate
6322: from mtl_system_items_b
6323: where inventory_item_id = p_inventory_item_id
6324: and organization_id = p_organization_id;
6325: EXCEPTION
6326: WHEN NO_DATA_FOUND THEN

Line 6526: -- Update mtl_system_items_b

6522:
6523: END LOOP;
6524:
6525: --
6526: -- Update mtl_system_items_b
6527: --
6528:
6529: IF ( p_template_id is null ) THEN
6530:

Line 6537: UPDATE MTL_SYSTEM_ITEMS_B

6533: p_organization_id => p_organization_id);
6534:
6535: IF (l_serial_exists = 2 ) THEN
6536:
6537: UPDATE MTL_SYSTEM_ITEMS_B
6538: SET serial_tagging_flag = 'Y'
6539: WHERE inventory_item_id = p_inventory_item_id
6540: AND organization_id = p_organization_id
6541: AND nvl(serial_tagging_flag,'N') = 'N';

Line 6545: UPDATE MTL_SYSTEM_ITEMS_B

6541: AND nvl(serial_tagging_flag,'N') = 'N';
6542:
6543: ELSE
6544:
6545: UPDATE MTL_SYSTEM_ITEMS_B
6546: SET serial_tagging_flag = 'N'
6547: WHERE inventory_item_id = p_inventory_item_id
6548: AND organization_id = p_organization_id
6549: AND serial_tagging_flag = 'Y';