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 358: FROM mtl_system_items_b

354: SELECT lifecycle_id,
355: current_phase_id,
356: item_catalog_group_id,
357: approval_status -- Added for 4046435
358: FROM mtl_system_items_b
359: WHERE inventory_item_id = P_Item_Id
360: AND organization_id IN
361: (SELECT organization_id
362: FROM mtl_parameters

Line 372: FROM mtl_system_items_b

368: ,cp_status_code VARCHAR2)IS
369: SELECT 'Y'
370: FROM DUAL
371: WHERE EXISTS ( SELECT NULL
372: FROM mtl_system_items_b
373: WHERE inventory_item_id = P_Item_Id
374: AND organization_id = P_Org_Id
375: AND NVL(approval_status,'A') <> 'A'
376: )

Line 392: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

388: SELECT display_sequence
389: FROM pa_ego_phases_v
390: WHERE proj_element_id = cp_phase_id ;
391:
392: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
393: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
394: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
395: l_valid_status VARCHAR2(1) := 'N';
396: l_Policy_Code VARCHAR2(20);

Line 393: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

389: FROM pa_ego_phases_v
390: WHERE proj_element_id = cp_phase_id ;
391:
392: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
393: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
394: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
395: l_valid_status VARCHAR2(1) := 'N';
396: l_Policy_Code VARCHAR2(20);
397: l_Return_Status VARCHAR2(1);

Line 394: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;

390: WHERE proj_element_id = cp_phase_id ;
391:
392: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
393: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
394: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
395: l_valid_status VARCHAR2(1) := 'N';
396: l_Policy_Code VARCHAR2(20);
397: l_Return_Status VARCHAR2(1);
398: l_Error_Code NUMBER;

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

397: l_Return_Status VARCHAR2(1);
398: l_Error_Code NUMBER;
399: l_Msg_Count NUMBER;
400: l_Msg_Data VARCHAR2(2000);
401: l_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4046435
402: -- Bug 5375723
403: l_old_disp_seq NUMBER;
404: l_new_disp_seq NUMBER;
405:

Line 548: FROM mtl_system_items_b

544: ,X_Error_Code OUT NOCOPY VARCHAR2) IS
545:
546: CURSOR c_get_master_details(cp_item_id NUMBER) IS
547: SELECT Lifecycle_id, Current_Phase_Id
548: FROM mtl_system_items_b
549: WHERE inventory_item_id = cp_item_id
550: AND organization_id IN
551: (SELECT organization_id
552: FROM mtl_parameters

Line 570: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

566: FROM mtl_item_attributes
567: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
568:
569:
570: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
571: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
572: l_status_control NUMBER(2) := 1; --Master controlled
573: BEGIN
574: X_Error_Code := NULL;

Line 571: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

567: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
568:
569:
570: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
571: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
572: l_status_control NUMBER(2) := 1; --Master controlled
573: BEGIN
574: X_Error_Code := NULL;
575: X_Error_Column := NULL;

Line 762: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;

758: SELECT base_uom_flag
759: FROM mtl_units_of_measure
760: WHERE uom_code = cp_primary_uom_code;
761:
762: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;
763: l_ret_status VARCHAR2(100);
764: l_valid_pack_type NUMBER := 0;
765: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;
766: l_old_gdsn_flag VARCHAR2(1);

Line 782: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;

778: X_MSG_COUNT NUMBER;
779: X_MSG_DATA VARCHAR2(240);
780: l_old_catalog_group_id NUMBER;
781: l_approval_status VARCHAR2(1);
782: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
783: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
784: l_valid VARCHAR2(100) := FND_API.G_TRUE;
785: l_is_gdsn NUMBER;
786: l_unit_wt_disp_name VARCHAR2(1000);

Line 783: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;

779: X_MSG_DATA VARCHAR2(240);
780: l_old_catalog_group_id NUMBER;
781: l_approval_status VARCHAR2(1);
782: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
783: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
784: l_valid VARCHAR2(100) := FND_API.G_TRUE;
785: l_is_gdsn NUMBER;
786: l_unit_wt_disp_name VARCHAR2(1000);
787: l_unit_wt_uom_disp_name VARCHAR2(1000);

Line 1732: FROM mtl_system_items_b

1728: IS
1729: SELECT item_catalog_group_id, approval_status,
1730: inventory_item_status_code,lifecycle_id,
1731: current_phase_id
1732: FROM mtl_system_items_b
1733: WHERE organization_id = cp_org_id
1734: AND inventory_item_id = cp_item_id;
1735:
1736: l_has_privilege VARCHAR2(1) := 'F';

Line 1746: l_approval_status mtl_system_items_b.approval_status%TYPE;

1742: l_error_code VARCHAR2(70);
1743: l_err_text VARCHAR2(240);
1744: l_item_catalog NUMBER := 0;
1745: l_has_access VARCHAR2(1):= 'F';
1746: l_approval_status mtl_system_items_b.approval_status%TYPE;
1747: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1748: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1749: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1750: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;

Line 1747: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

1743: l_err_text VARCHAR2(240);
1744: l_item_catalog NUMBER := 0;
1745: l_has_access VARCHAR2(1):= 'F';
1746: l_approval_status mtl_system_items_b.approval_status%TYPE;
1747: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1748: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1749: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1750: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1751: BEGIN

Line 2335: FROM MTL_SYSTEM_ITEMS_B

2331: CURSOR c_get_existing_item_record(cp_item_id NUMBER, cp_org_id NUMBER) IS
2332: SELECT item_catalog_group_id
2333: ,lifecycle_id
2334: ,current_phase_id
2335: FROM MTL_SYSTEM_ITEMS_B
2336: WHERE inventory_item_id = cp_item_id
2337: AND organization_id = cp_org_id;
2338:
2339:

Line 2878: UPDATE MTL_SYSTEM_ITEMS_B

2874: FETCH c_nir_reqd INTO l_nir_reqd;
2875: CLOSE c_nir_reqd;
2876:
2877: IF l_nir_reqd = 'Y' THEN
2878: UPDATE MTL_SYSTEM_ITEMS_B
2879: SET INVENTORY_ITEM_STATUS_CODE='Pending'
2880: ,APPROVAL_STATUS = 'N'
2881: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
2882: WHERE INVENTORY_ITEM_ID = nir_item.inventory_item_id

Line 3019: UPDATE MTL_SYSTEM_ITEMS_B

3015: FOR i in c_get_processed_records(p_set_process_id) LOOP
3016: --Ideally this update should be done only after NIR created succesfully
3017: -- but for technical reasons we are not stoping item creation even though
3018: -- NIR is not created.
3019: UPDATE MTL_SYSTEM_ITEMS_B
3020: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3021: ,APPROVAL_STATUS = 'N'
3022: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3023: WHERE INVENTORY_ITEM_ID = i.inventory_item_id

Line 3494: UPDATE mtl_system_items_b

3490: END IF;
3491: END IF; --IF l_raise_create_nir AND NOT l_error_occured THEN
3492:
3493: IF l_update_msb AND NOT l_error_occured THEN
3494: UPDATE mtl_system_items_b
3495: SET approval_status = 'A'
3496: WHERE inventory_item_id = p_inventory_item_id
3497: AND organization_id = p_organization_id;
3498: END IF;

Line 3599: UPDATE MTL_SYSTEM_ITEMS_B

3595: SELECT new_item_req_change_type_id INTO l_type_id
3596: FROM mtl_item_catalog_groups_b
3597: WHERE item_catalog_group_id = p_item_catalog_group_id;
3598:
3599: UPDATE MTL_SYSTEM_ITEMS_B
3600: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3601: ,APPROVAL_STATUS = 'N'
3602: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3603: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 3667: UPDATE MTL_SYSTEM_ITEMS_B

3663: l_msg_count NUMBER;
3664: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3665: l_proc_flag NUMBER;
3666: BEGIN
3667: UPDATE MTL_SYSTEM_ITEMS_B
3668: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3669: ,APPROVAL_STATUS = 'N'
3670: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3671: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 3763: FROM mtl_system_items_b

3759: Cp_organization_id IN NUMBER)
3760: IS
3761: SELECT style_item_flag,style_item_id,
3762: item_catalog_group_id
3763: FROM mtl_system_items_b
3764: WHERE inventory_item_id = cp_inventory_item_id
3765: AND organization_id = cp_organization_id;
3766:
3767: l_user_id NUMBER := FND_GLOBAL.User_Id;

Line 3902: FROM mtl_system_items_b

3898: (l_transaction_type = 'UPDATE' AND NVL(l_msi_icc_id,l_null_icc_id) <> NVL(l_msii_icc_id,l_null_icc_id)) )THEN
3899: /* Styles to be created in only those ICCs that contain Variant AGs - Sec 2.5.1 -Condition 2 */
3900: IF l_msii_style_item_flag = 'Y' THEN
3901: SELECT COUNT(*) INTO l_sku_exists
3902: FROM mtl_system_items_b
3903: WHERE style_item_id = l_msii_inv_item_id
3904: AND organization_id = l_msii_org_id;
3905:
3906: IF l_sku_exists <> 0 THEN

Line 3978: FROM mtl_system_items_b

3974: END IF; --Style Item
3975: ELSE
3976: BEGIN
3977: SELECT item_catalog_group_id INTO l_style_icc_id
3978: FROM mtl_system_items_b
3979: WHERE inventory_item_id = l_msii_style_item_id
3980: AND organization_id = l_msii_org_id;
3981: EXCEPTION
3982: WHEN no_data_found THEN