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

576: l_policy_check_sql VARCHAR2(32767);
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'||

Line 673: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;

669: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
670: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;
671: l_policy_cat_id NUMBER;
672: l_catalog_category_names_table LOCAL_MEDIUM_VARCHAR_TABLE;
673: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
674: l_row_identifier NUMBER;
675: i NUMBER :=0;
676: BEGIN
677: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

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

696:
697: l_token_table(1).TOKEN_NAME := 'ATTR_GROUP_NAME';
698: l_token_table(1).TOKEN_VALUE := l_current_data_element.ATTR_GROUP_NAME;
699:
700: SELECT segment1 INTO l_item_number FROM MTL_SYSTEM_ITEMS_B WHERE inventory_item_id=p_inventory_item_id;
701:
702:
703: l_token_table(2).TOKEN_NAME := 'ITEM_NUMBER';
704: l_token_table(2).TOKEN_VALUE := l_item_number;

Line 708: FROM MTL_SYSTEM_ITEMS_B MSI

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

Line 719: FROM MTL_SYSTEM_ITEMS_B MSI

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

Line 734: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI

730: FROM (SELECT item_catalog_group_id
731: FROM mtl_item_catalog_groups_b ic
732: WHERE EXISTS
733: ( SELECT olc.object_classification_code CatalogId
734: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI
735: WHERE olc.object_id = l_object_id
736: AND olc.lifecycle_id = MSI.lifecycle_id
737: AND MSI.inventory_item_id = p_inventory_item_id
738: AND MSI.organization_id = p_organization_id

Line 744: FROM MTL_SYSTEM_ITEMS_B

740: )
741: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
742: START WITH item_catalog_group_id
743: =(SELECT item_catalog_group_id
744: FROM MTL_SYSTEM_ITEMS_B
745: WHERE inventory_item_id=p_inventory_item_id
746: )
747: ) CAT_HIER
748: WHERE ROWNUM = 1;

Line 1518: FROM MTL_SYSTEM_ITEMS_B

1514: -----------------------------------------------------------------------
1515: -- added for bug 7431714
1516: SELECT item_catalog_group_id
1517: INTO l_curr_icc_id
1518: FROM MTL_SYSTEM_ITEMS_B
1519: WHERE inventory_item_id = l_Item_rec_in.INVENTORY_ITEM_ID
1520: AND organization_id = l_Item_rec_in.ORGANIZATION_ID;
1521:
1522: IF (l_Item_rec_in.ITEM_CATALOG_GROUP_ID <> l_curr_icc_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 1817: l_master_org INV.MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1814: l_rev_index_failure BOOLEAN := FALSE;
1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1816: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
1817: l_master_org INV.MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
1818: l_event_return_status VARCHAR2(1) ; --business event enhancement
1819: l_item_rev_rec c_get_item_rev_rec%ROWTYPE;
1820: l_msg_data VARCHAR2(2000);
1821: l_process_control VARCHAR2(2000) := INV_EGO_REVISION_VALIDATE.Get_Process_Control; --Bug: 4881908

Line 2552: FROM MTL_SYSTEM_ITEMS_B

2548: -- Bug: 5636895 added NVL(ITEM...., -1)
2549: BEGIN
2550: SELECT NVL(ITEM_CATALOG_GROUP_ID, -1)
2551: INTO l_item_catalog_group_id
2552: FROM MTL_SYSTEM_ITEMS_B
2553: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2554: AND ORGANIZATION_ID = p_organization_id;
2555: EXCEPTION
2556: WHEN NO_DATA_FOUND THEN

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

3183: l_dummy_char VARCHAR2(32767);
3184: l_sysdate DATE;
3185: l_start_date DATE;
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;

Line 3188: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

3184: l_sysdate DATE;
3185: l_start_date DATE;
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;

Line 3189: l_approval_status mtl_system_items_b.approval_status%TYPE;

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

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

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

Line 3721: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

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

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

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

Line 3726: l_curr_cc_id mtl_system_items_b.item_catalog_group_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;
3730: l_item_sequence NUMBER;

Line 3727: l_curr_lifecycle_id mtl_system_items_b.lifecycle_id%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;
3730: l_item_sequence NUMBER;
3731: l_phase_sequence NUMBER;

Line 3728: l_curr_phase_id mtl_system_items_b.current_phase_id%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;
3730: l_item_sequence NUMBER;
3731: l_phase_sequence NUMBER;
3732: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;

Line 3729: l_future_phase_id mtl_system_items_b.current_phase_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;
3730: l_item_sequence NUMBER;
3731: l_phase_sequence NUMBER;
3732: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;
3733: l_policy_code VARCHAR2(99);

Line 3732: l_curr_status mtl_system_items_b.inventory_item_status_code%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;
3730: l_item_sequence NUMBER;
3731: l_phase_sequence NUMBER;
3732: l_curr_status mtl_system_items_b.inventory_item_status_code%TYPE;
3733: l_policy_code VARCHAR2(99);
3734: l_policy_co_required VARCHAR2(99);
3735: l_policy_not_allowed VARCHAR2(99);
3736: l_sysdate DATE;

Line 3754: FROM mtl_system_items_b

3750: CURSOR c_get_item_det (cp_inventory_item_id IN NUMBER
3751: ,cp_organization_id IN NUMBER) IS
3752: SELECT item_catalog_group_id, lifecycle_id,
3753: current_phase_id, inventory_item_status_code
3754: FROM mtl_system_items_b
3755: WHERE inventory_item_id = cp_inventory_item_id
3756: AND organization_id = cp_organization_id;
3757:
3758: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER

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

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

Line 4385: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

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

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

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

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

Line 4845: FROM MTL_SYSTEM_ITEMS_B

4841:
4842: CURSOR get_catalog_group_id IS
4843: SELECT ITEM_CATALOG_GROUP_ID
4844: INTO l_item_catalog_group_id
4845: FROM MTL_SYSTEM_ITEMS_B
4846: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
4847: AND ORGANIZATION_ID = p_organization_id;
4848:
4849: BEGIN