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.INV_EGO_REVISION_VALIDATE dependencies on MTL_SYSTEM_ITEMS_B

Line 340: FROM mtl_system_items_b

336: SELECT lifecycle_id,
337: current_phase_id,
338: item_catalog_group_id,
339: approval_status -- Added for 4046435
340: FROM mtl_system_items_b
341: WHERE inventory_item_id = P_Item_Id
342: /*Changed for FP bug 8213894 with base bug 7492587*/
343: /* AND organization_id IN
344: (SELECT organization_id

Line 356: FROM mtl_system_items_b

352: ,cp_status_code VARCHAR2)IS
353: SELECT 'Y'
354: FROM DUAL
355: WHERE EXISTS ( SELECT NULL
356: FROM mtl_system_items_b
357: WHERE inventory_item_id = P_Item_Id
358: AND organization_id = P_Org_Id
359: AND NVL(approval_status,'A') <> 'A'
360: )

Line 376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

372: SELECT display_sequence
373: FROM pa_ego_phases_v
374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
379: l_valid_status VARCHAR2(1) := 'N';
380: l_Policy_Code VARCHAR2(20);

Line 377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

373: FROM pa_ego_phases_v
374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
379: l_valid_status VARCHAR2(1) := 'N';
380: l_Policy_Code VARCHAR2(20);
381: l_Return_Status VARCHAR2(1);

Line 378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;

374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
379: l_valid_status VARCHAR2(1) := 'N';
380: l_Policy_Code VARCHAR2(20);
381: l_Return_Status VARCHAR2(1);
382: l_Error_Code NUMBER;

Line 385: l_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4046435

381: l_Return_Status VARCHAR2(1);
382: l_Error_Code NUMBER;
383: l_Msg_Count NUMBER;
384: l_Msg_Data VARCHAR2(2000);
385: l_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4046435
386: -- Bug 5375723
387: l_old_disp_seq NUMBER;
388: l_new_disp_seq NUMBER;
389:

Line 537: FROM mtl_system_items_b

533: ,X_Error_Code OUT NOCOPY VARCHAR2) IS
534:
535: CURSOR c_get_master_details(cp_item_id NUMBER) IS
536: SELECT Lifecycle_id, Current_Phase_Id
537: FROM mtl_system_items_b
538: WHERE inventory_item_id = cp_item_id
539: AND organization_id IN
540: (SELECT organization_id
541: FROM mtl_parameters

Line 559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

555: FROM mtl_item_attributes
556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
557:
558:
559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
561: l_status_control NUMBER(2) := 1; --Master controlled
562: BEGIN
563: X_Error_Code := NULL;

Line 560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
557:
558:
559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
561: l_status_control NUMBER(2) := 1; --Master controlled
562: BEGIN
563: X_Error_Code := NULL;
564: X_Error_Column := NULL;

Line 771: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;

767: WHERE NVL(eng_item_flag,'N')='N'
768: AND rowid = cp_row_id);
769:
770: l_valid_status VARCHAR2(1) := 'N';
771: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;
772: l_ret_status VARCHAR2(100);
773: l_valid_pack_type NUMBER := 0;
774: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;
775: l_old_gdsn_flag VARCHAR2(1);

Line 791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;

787: X_MSG_COUNT NUMBER;
788: X_MSG_DATA VARCHAR2(240);
789: l_old_catalog_group_id NUMBER;
790: l_approval_status VARCHAR2(1);
791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
793: l_valid VARCHAR2(100) := FND_API.G_TRUE;
794: l_is_gdsn NUMBER;
795: l_unit_wt_disp_name VARCHAR2(1000);

Line 792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;

788: X_MSG_DATA VARCHAR2(240);
789: l_old_catalog_group_id NUMBER;
790: l_approval_status VARCHAR2(1);
791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
793: l_valid VARCHAR2(100) := FND_API.G_TRUE;
794: l_is_gdsn NUMBER;
795: l_unit_wt_disp_name VARCHAR2(1000);
796: l_unit_wt_uom_disp_name VARCHAR2(1000);

Line 800: l_old_lifecycle_id MTL_SYSTEM_ITEMS_B.lifecycle_id%TYPE;

796: l_unit_wt_uom_disp_name VARCHAR2(1000);
797: l_gtid_disp_name VARCHAR2(1000);
798:
799: -- Bug 11768298 : Start
800: l_old_lifecycle_id MTL_SYSTEM_ITEMS_B.lifecycle_id%TYPE;
801: l_old_current_phase_id MTL_SYSTEM_ITEMS_B.current_phase_id%TYPE;
802: -- Bug 11768298 : End
803:
804: BEGIN

Line 801: l_old_current_phase_id MTL_SYSTEM_ITEMS_B.current_phase_id%TYPE;

797: l_gtid_disp_name VARCHAR2(1000);
798:
799: -- Bug 11768298 : Start
800: l_old_lifecycle_id MTL_SYSTEM_ITEMS_B.lifecycle_id%TYPE;
801: l_old_current_phase_id MTL_SYSTEM_ITEMS_B.current_phase_id%TYPE;
802: -- Bug 11768298 : End
803:
804: BEGIN
805:

Line 1830: FROM mtl_system_items_b

1826: IS
1827: SELECT item_catalog_group_id, approval_status,
1828: inventory_item_status_code,lifecycle_id,
1829: current_phase_id
1830: FROM mtl_system_items_b
1831: WHERE organization_id = cp_org_id
1832: AND inventory_item_id = cp_item_id;
1833:
1834: l_has_privilege VARCHAR2(1) := 'F';

Line 1844: l_approval_status mtl_system_items_b.approval_status%TYPE;

1840: l_error_code VARCHAR2(70);
1841: l_err_text VARCHAR2(240);
1842: l_item_catalog NUMBER := 0;
1843: l_has_access VARCHAR2(1):= 'F';
1844: l_approval_status mtl_system_items_b.approval_status%TYPE;
1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;

Line 1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

1841: l_err_text VARCHAR2(240);
1842: l_item_catalog NUMBER := 0;
1843: l_has_access VARCHAR2(1):= 'F';
1844: l_approval_status mtl_system_items_b.approval_status%TYPE;
1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1849: BEGIN

Line 2506: FROM MTL_SYSTEM_ITEMS_B

2502: CURSOR c_get_existing_item_record(cp_item_id NUMBER, cp_org_id NUMBER) IS
2503: SELECT item_catalog_group_id
2504: ,lifecycle_id
2505: ,current_phase_id
2506: FROM MTL_SYSTEM_ITEMS_B
2507: WHERE inventory_item_id = cp_item_id
2508: AND organization_id = cp_org_id;
2509:
2510:

Line 3049: UPDATE MTL_SYSTEM_ITEMS_B

3045: FETCH c_nir_reqd INTO l_nir_reqd;
3046: CLOSE c_nir_reqd;
3047:
3048: IF l_nir_reqd = 'Y' THEN
3049: UPDATE MTL_SYSTEM_ITEMS_B
3050: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3051: ,APPROVAL_STATUS = 'N'
3052: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3053: WHERE INVENTORY_ITEM_ID = nir_item.inventory_item_id

Line 3064: UPDATE mtl_system_items_b

3060:
3061: --EMTAPIA: added for bug 7036113
3062: /* Bug 8799957. Replacing LEVEL = 1 condition with ROWNUM = 1 to check if New Item Request is
3063: required or not, in case child ICC is inheriting NIR from parent ICC */
3064: UPDATE mtl_system_items_b
3065: SET inventory_item_status_code = 'Pending',
3066: approval_status = 'N',
3067: current_phase_id = DECODE(lifecycle_id, NULL, NULL,
3068: Get_Initial_Lifecycle_Phase(lifecycle_id))

Line 3229: UPDATE MTL_SYSTEM_ITEMS_B

3225: FOR i in c_get_processed_records(p_set_process_id) LOOP
3226: --Ideally this update should be done only after NIR created succesfully
3227: -- but for technical reasons we are not stoping item creation even though
3228: -- NIR is not created.
3229: UPDATE MTL_SYSTEM_ITEMS_B
3230: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3231: ,APPROVAL_STATUS = 'N'
3232: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3233: WHERE INVENTORY_ITEM_ID = i.inventory_item_id

Line 3715: UPDATE mtl_system_items_b

3711: END IF;
3712: END IF; --IF l_raise_create_nir AND NOT l_error_occured THEN
3713:
3714: IF l_update_msb AND NOT l_error_occured THEN
3715: UPDATE mtl_system_items_b
3716: SET approval_status = 'A'
3717: WHERE inventory_item_id = p_inventory_item_id
3718: AND organization_id = p_organization_id;
3719: END IF;

Line 3820: UPDATE MTL_SYSTEM_ITEMS_B

3816: SELECT new_item_req_change_type_id INTO l_type_id
3817: FROM mtl_item_catalog_groups_b
3818: WHERE item_catalog_group_id = p_item_catalog_group_id;
3819:
3820: UPDATE MTL_SYSTEM_ITEMS_B
3821: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3822: ,APPROVAL_STATUS = 'N'
3823: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3824: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 3888: UPDATE MTL_SYSTEM_ITEMS_B

3884: l_msg_count NUMBER;
3885: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3886: l_proc_flag NUMBER;
3887: BEGIN
3888: UPDATE MTL_SYSTEM_ITEMS_B
3889: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3890: ,APPROVAL_STATUS = 'N'
3891: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3892: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 4023: FROM mtl_system_items_b

4019: Cp_organization_id IN NUMBER)
4020: IS
4021: SELECT style_item_flag,style_item_id,
4022: item_catalog_group_id
4023: FROM mtl_system_items_b
4024: WHERE inventory_item_id = cp_inventory_item_id
4025: AND organization_id = cp_organization_id;
4026:
4027: l_user_id NUMBER := FND_GLOBAL.User_Id;

Line 4162: FROM mtl_system_items_b

4158: (l_transaction_type = 'UPDATE' AND NVL(l_msi_icc_id,l_null_icc_id) <> NVL(l_msii_icc_id,l_null_icc_id)) )THEN
4159: /* Styles to be created in only those ICCs that contain Variant AGs - Sec 2.5.1 -Condition 2 */
4160: IF l_msii_style_item_flag = 'Y' THEN
4161: SELECT COUNT(*) INTO l_sku_exists
4162: FROM mtl_system_items_b
4163: WHERE style_item_id = l_msii_inv_item_id
4164: AND organization_id = l_msii_org_id;
4165:
4166: IF l_sku_exists <> 0 THEN

Line 4238: FROM mtl_system_items_b

4234: END IF; --Style Item
4235: ELSE
4236: BEGIN
4237: SELECT item_catalog_group_id INTO l_style_icc_id
4238: FROM mtl_system_items_b
4239: WHERE inventory_item_id = l_msii_style_item_id
4240: AND organization_id = l_msii_org_id;
4241: EXCEPTION
4242: WHEN no_data_found THEN