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_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 918: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;

914: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
915: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
916: l_approval_status VARCHAR2(30);
917: l_template_applied BOOLEAN := FALSE;
918: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;
919:
920: CURSOR c_get_obj_version_num(cp_inventory_item_id IN NUMBER
921: ,cp_organization_id IN NUMBER ) IS
922: SELECT object_version_number

Line 923: FROM mtl_system_items_b

919:
920: CURSOR c_get_obj_version_num(cp_inventory_item_id IN NUMBER
921: ,cp_organization_id IN NUMBER ) IS
922: SELECT object_version_number
923: FROM mtl_system_items_b
924: WHERE inventory_item_id = cp_inventory_item_id
925: AND organization_id = cp_organization_id;
926:
927: -- Bug 9852661

Line 1979: UPDATE mtl_system_items_b

1975: ,P_Item_Catalog_Group_Id => l_catalog);
1976:
1977: IF l_Item_Id IS NULL THEN
1978:
1979: UPDATE mtl_system_items_b
1980: SET segment1 = l_Segment_Rec.segment1
1981: ,segment2 = l_Segment_Rec.segment2
1982: ,segment3 = l_Segment_Rec.segment3
1983: ,segment4 = l_Segment_Rec.segment4

Line 2198: old_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;

2194: ,p_commit IN VARCHAR2 DEFAULT G_FALSE)
2195: IS
2196: l_eng_item_flag VARCHAR2(10);
2197: l_msg_data VARCHAR2(2000);
2198: old_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;
2199: l_event_return_status VARCHAR2(1);
2200: BEGIN
2201: --get old Approval Status, needed for Raising event.
2202: SELECT APPROVAL_STATUS INTO old_approval_status

Line 2203: FROM MTL_SYSTEM_ITEMS_B

2199: l_event_return_status VARCHAR2(1);
2200: BEGIN
2201: --get old Approval Status, needed for Raising event.
2202: SELECT APPROVAL_STATUS INTO old_approval_status
2203: FROM MTL_SYSTEM_ITEMS_B
2204: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2205: AND ORGANIZATION_ID = p_organization_id;
2206:
2207: UPDATE MTL_SYSTEM_ITEMS_B

Line 2207: UPDATE MTL_SYSTEM_ITEMS_B

2203: FROM MTL_SYSTEM_ITEMS_B
2204: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2205: AND ORGANIZATION_ID = p_organization_id;
2206:
2207: UPDATE MTL_SYSTEM_ITEMS_B
2208: SET APPROVAL_STATUS = p_approval_status
2209: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2210: AND ORGANIZATION_ID = p_organization_id
2211: RETURNING ENG_ITEM_FLAG INTO l_eng_item_flag;

Line 2255: UPDATE MTL_SYSTEM_ITEMS_B

2251: -- R12-C: Since Items can now have multiple NIRs, we will store the latest
2252: --NIR that cause the approval status change for an item in MSIB.
2253: IF NVL(p_approval_status,'0') <> NVL(OLD_APPROVAL_STATUS,'0')
2254: AND p_nir_id IS NOT NULL THEN
2255: UPDATE MTL_SYSTEM_ITEMS_B
2256: SET LAST_SUBMITTED_NIR_ID = p_nir_id
2257: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2258: AND ORGANIZATION_ID = p_organization_id;
2259: END IF;

Line 2295: FROM mtl_system_items_b

2291:
2292: CURSOR c_copy_item_info (cp_inventory_item_id IN NUMBER
2293: ,cp_organization_id IN NUMBER ) IS
2294: SELECT *
2295: FROM mtl_system_items_b
2296: WHERE inventory_item_id = cp_inventory_item_id
2297: AND organization_id = cp_organization_id;
2298:
2299: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

Line 2299: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

2295: FROM mtl_system_items_b
2296: WHERE inventory_item_id = cp_inventory_item_id
2297: AND organization_id = cp_organization_id;
2298:
2299: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
2300:
2301: BEGIN
2302:
2303: OPEN c_copy_item_info (cp_inventory_item_id => p_inventory_item_id

Line 2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',

2707: WHERE NVL(a.status_control_code, 3) <> 1
2708: AND a.control_level IN (1, 2)
2709: AND a.attribute_group_id_gui IS NOT NULL
2710: AND a.attribute_name NOT IN
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',

Line 2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',

2710: AND a.attribute_name NOT IN
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',

Line 2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',

2733: WHERE NVL(a.status_control_code, 3) <> 1
2734: AND a.control_level IN (1, 2)
2735: AND a.attribute_group_id_gui IS NOT NULL
2736: AND a.attribute_name IN
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',

Line 2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',

2736: AND a.attribute_name IN
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',

Line 2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

2834: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2835: x_item_table(p_tab_index).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2837: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

Line 2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN

2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2837: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN

Line 2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2845: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN

Line 2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN

2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2845: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2847: x_item_table(p_tab_index).CARRYING_COST := cr.ATTRIBUTE_VALUE;
2848: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN

Line 3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN

3136: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
3137: x_item_table(p_tab_index).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
3138: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
3139: x_item_table(p_tab_index).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
3141: x_item_table(p_tab_index).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
3142: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
3143: x_item_table(p_tab_index).WEB_STATUS := cr.ATTRIBUTE_VALUE;
3144: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN

Line 3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN

3150: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3151: x_item_table(p_tab_index).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
3152: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3153: x_item_table(p_tab_index).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3155: x_item_table(p_tab_index).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
3156: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3157: x_item_table(p_tab_index).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3158: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN

Line 3348: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN

3344:
3345: IF ( (l_org_id is NOT NULL) AND (l_org_id = p_organization_id) ) THEN
3346: FOR cr IN c_get_org_template_attributes (cp_template_id => p_template_id) LOOP
3347:
3348: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
3349: x_item_table(p_tab_index).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
3350: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
3351: x_item_table(p_tab_index).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3352: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN

Line 3539: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

3535: END IF;
3536: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3537: X_MSG_COUNT := 0;
3538:
3539: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3540: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3541: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3542:
3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

3539: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3540: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3541: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3542:
3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3544: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3545: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3546:
3547: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS

Line 3547: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS

3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3544: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3545: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3546:
3547: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
3548: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3549: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3550:
3551: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID

Line 3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,

3591: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3592: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3593:
3594: /*CURSOR ego_item_assigned_org_csr (
3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3597: IS
3598: SELECT ORGANIZATION_ID
3599: FROM MTL_SYSTEM_ITEMS_VL

Line 3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)

3592: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3593:
3594: /*CURSOR ego_item_assigned_org_csr (
3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3597: IS
3598: SELECT ORGANIZATION_ID
3599: FROM MTL_SYSTEM_ITEMS_VL
3600: WHERE INVENTORY_ITEM_ID = v_inventory_item_id

Line 3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,

3601: AND ORGANIZATION_ID <> v_master_organization_id;
3602: */
3603: /*Added for bug 7660662*/
3604: CURSOR ego_item_all_assigned_org_csr (
3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi

Line 3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)

3602: */
3603: /*Added for bug 7660662*/
3604: CURSOR ego_item_all_assigned_org_csr (
3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi
3610: WHERE msi.INVENTORY_ITEM_ID = v_inventory_item_id

Line 3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL

3651: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3652: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3653: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP
3654:
3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3656: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3657: AND ORGANIZATION_ID = rec.organization_id;
3658:
3659: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL

Line 3659: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL

3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3656: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3657: AND ORGANIZATION_ID = rec.organization_id;
3658:
3659: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
3660: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3661: AND ORGANIZATION_ID = rec.organization_id;
3662:
3663: /*Added for bug 7659489*/

Line 3732: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

3728: IF ((L_CONTROL_LEVEL = 1) AND (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID))
3729: THEN
3730: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP
3731:
3732: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3733: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3734: AND ORGANIZATION_ID = rec.organization_id;
3735:
3736: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 3736: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

3732: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3733: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3734: AND ORGANIZATION_ID = rec.organization_id;
3735:
3736: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3737: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3738: AND ORGANIZATION_ID = rec.organization_id;
3739:
3740: if(L_UPDATE_STATUS_HIS_IND) then

Line 3772: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

3768: END LOOP;
3769: /*If Org controlled then insert only for the specific organization with pending status as 'N'*/
3770: ELSIF (L_CONTROL_LEVEL = 2) THEN
3771: -- Org Control
3772: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3773: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3774: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3775:
3776: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 3776: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

3772: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3773: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3774: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3775:
3776: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3777: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3778: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3779:
3780: if(L_UPDATE_STATUS_HIS_IND) then

Line 3930: FROM mtl_system_items_b a

3926: START WITH b.item_catalog_group_id = p_catalog_group_id;
3927:
3928: IF l_cat_count = 0 THEN
3929: SELECT COUNT(1) into l_total_count
3930: FROM mtl_system_items_b a
3931: WHERE a.organization_id = p_organization_id;
3932: ELSE
3933: SELECT COUNT(1) into l_total_count FROM mtl_system_items_b a
3934: WHERE a.organization_id = p_organization_id

Line 3933: SELECT COUNT(1) into l_total_count FROM mtl_system_items_b a

3929: SELECT COUNT(1) into l_total_count
3930: FROM mtl_system_items_b a
3931: WHERE a.organization_id = p_organization_id;
3932: ELSE
3933: SELECT COUNT(1) into l_total_count FROM mtl_system_items_b a
3934: WHERE a.organization_id = p_organization_id
3935: AND item_catalog_group_id in (SELECT item_catalog_group_id
3936: FROM mtl_item_catalog_groups_b b
3937: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id

Line 4158: ' FROM mtl_system_items_b ' ||

4154: -- ENG exists
4155: -- check for policy control
4156: l_dynamic_sql :=
4157: ' SELECT item_catalog_group_id, lifecycle_id, current_phase_id' ||
4158: ' FROM mtl_system_items_b ' ||
4159: ' WHERE inventory_item_id = :1' ||
4160: ' AND organization_id = :2';
4161: EXECUTE IMMEDIATE l_dynamic_sql
4162: INTO l_catalog_category_id, l_lifecycle_id, l_current_phase_id

Line 4629: FROM MTL_SYSTEM_ITEMS_B_KFV

4625: BEGIN
4626: IF p_inventory_item_id IS NULL THEN
4627: IF p_item_number IS NOT NULL THEN
4628: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4629: FROM MTL_SYSTEM_ITEMS_B_KFV
4630: WHERE ORGANIZATION_ID = l_organization_id
4631: AND CONCATENATED_SEGMENTS = p_item_number;
4632: ELSE
4633: RAISE INVALID_ITEM;

Line 4637: FROM MTL_SYSTEM_ITEMS_B_KFV

4633: RAISE INVALID_ITEM;
4634: END IF;
4635: ELSE
4636: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4637: FROM MTL_SYSTEM_ITEMS_B_KFV
4638: WHERE ORGANIZATION_ID = l_organization_id
4639: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4640: END IF;
4641: