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 904: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;

900: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
901: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
902: l_approval_status VARCHAR2(30);
903: l_template_applied BOOLEAN := FALSE;
904: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;
905:
906: CURSOR c_get_obj_version_num(cp_inventory_item_id IN NUMBER
907: ,cp_organization_id IN NUMBER ) IS
908: SELECT object_version_number

Line 909: FROM mtl_system_items_b

905:
906: CURSOR c_get_obj_version_num(cp_inventory_item_id IN NUMBER
907: ,cp_organization_id IN NUMBER ) IS
908: SELECT object_version_number
909: FROM mtl_system_items_b
910: WHERE inventory_item_id = cp_inventory_item_id
911: AND organization_id = cp_organization_id;
912:
913: BEGIN

Line 1832: UPDATE mtl_system_items_b

1828: ,P_Item_Catalog_Group_Id => l_catalog);
1829:
1830: IF l_Item_Id IS NULL THEN
1831:
1832: UPDATE mtl_system_items_b
1833: SET segment1 = l_Segment_Rec.segment1
1834: ,segment2 = l_Segment_Rec.segment2
1835: ,segment3 = l_Segment_Rec.segment3
1836: ,segment4 = l_Segment_Rec.segment4

Line 2051: old_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;

2047: ,p_commit IN VARCHAR2 DEFAULT G_FALSE)
2048: IS
2049: l_eng_item_flag VARCHAR2(10);
2050: l_msg_data VARCHAR2(2000);
2051: old_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;
2052: l_event_return_status VARCHAR2(1);
2053: BEGIN
2054: --get old Approval Status, needed for Raising event.
2055: SELECT APPROVAL_STATUS INTO old_approval_status

Line 2056: FROM MTL_SYSTEM_ITEMS_B

2052: l_event_return_status VARCHAR2(1);
2053: BEGIN
2054: --get old Approval Status, needed for Raising event.
2055: SELECT APPROVAL_STATUS INTO old_approval_status
2056: FROM MTL_SYSTEM_ITEMS_B
2057: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2058: AND ORGANIZATION_ID = p_organization_id;
2059:
2060: UPDATE MTL_SYSTEM_ITEMS_B

Line 2060: UPDATE MTL_SYSTEM_ITEMS_B

2056: FROM MTL_SYSTEM_ITEMS_B
2057: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2058: AND ORGANIZATION_ID = p_organization_id;
2059:
2060: UPDATE MTL_SYSTEM_ITEMS_B
2061: SET APPROVAL_STATUS = p_approval_status
2062: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2063: AND ORGANIZATION_ID = p_organization_id
2064: RETURNING ENG_ITEM_FLAG INTO l_eng_item_flag;

Line 2105: UPDATE MTL_SYSTEM_ITEMS_B

2101: -- R12-C: Since Items can now have multiple NIRs, we will store the latest
2102: --NIR that cause the approval status change for an item in MSIB.
2103: IF NVL(p_approval_status,'0') <> NVL(OLD_APPROVAL_STATUS,'0')
2104: AND p_nir_id IS NOT NULL THEN
2105: UPDATE MTL_SYSTEM_ITEMS_B
2106: SET LAST_SUBMITTED_NIR_ID = p_nir_id
2107: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2108: AND ORGANIZATION_ID = p_organization_id;
2109: END IF;

Line 2144: FROM mtl_system_items_b

2140:
2141: CURSOR c_copy_item_info (cp_inventory_item_id IN NUMBER
2142: ,cp_organization_id IN NUMBER ) IS
2143: SELECT *
2144: FROM mtl_system_items_b
2145: WHERE inventory_item_id = cp_inventory_item_id
2146: AND organization_id = cp_organization_id;
2147:
2148: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

Line 2148: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

2144: FROM mtl_system_items_b
2145: WHERE inventory_item_id = cp_inventory_item_id
2146: AND organization_id = cp_organization_id;
2147:
2148: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
2149:
2150: BEGIN
2151:
2152: OPEN c_copy_item_info (cp_inventory_item_id => p_inventory_item_id

Line 2560: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',

2556: WHERE NVL(a.status_control_code, 3) <> 1
2557: AND a.control_level IN (1, 2)
2558: AND a.attribute_group_id_gui IS NOT NULL
2559: AND a.attribute_name NOT IN
2560: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2561: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2562: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2563: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2564: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',

Line 2563: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',

2559: AND a.attribute_name NOT IN
2560: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2561: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2562: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2563: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2564: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2565: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2566: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2567: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',

Line 2586: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',

2582: WHERE NVL(a.status_control_code, 3) <> 1
2583: AND a.control_level IN (1, 2)
2584: AND a.attribute_group_id_gui IS NOT NULL
2585: AND a.attribute_name IN
2586: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2587: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2588: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2589: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2590: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',

Line 2589: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',

2585: AND a.attribute_name IN
2586: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2587: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2588: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2589: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2590: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2591: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2592: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2593: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',

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

2683: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2684: x_item_table(p_tab_index).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
2685: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2686: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2687: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2688: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2689: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2690: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2691: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

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

2685: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2686: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2687: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2688: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2689: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2690: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2691: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2692: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2693: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN

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

2687: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2688: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2689: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2690: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2691: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2692: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2693: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2694: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2695: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN

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

2689: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2690: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2691: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2692: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2693: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2694: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2695: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2696: x_item_table(p_tab_index).CARRYING_COST := cr.ATTRIBUTE_VALUE;
2697: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN

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

2985: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
2986: x_item_table(p_tab_index).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
2987: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
2988: x_item_table(p_tab_index).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
2989: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
2990: x_item_table(p_tab_index).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
2991: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
2992: x_item_table(p_tab_index).WEB_STATUS := cr.ATTRIBUTE_VALUE;
2993: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN

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

2999: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3000: x_item_table(p_tab_index).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
3001: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3002: x_item_table(p_tab_index).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
3003: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3004: x_item_table(p_tab_index).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
3005: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3006: x_item_table(p_tab_index).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3007: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN

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

3193:
3194: IF ( (l_org_id is NOT NULL) AND (l_org_id = p_organization_id) ) THEN
3195: FOR cr IN c_get_org_template_attributes (cp_template_id => p_template_id) LOOP
3196:
3197: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
3198: x_item_table(p_tab_index).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
3199: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
3200: x_item_table(p_tab_index).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3201: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN

Line 3346: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

3342: END IF;
3343: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3344: X_MSG_COUNT := 0;
3345:
3346: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3347: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3348: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3349:
3350: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 3350: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

3346: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3347: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3348: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3349:
3350: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3351: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3352: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3353:
3354: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS

Line 3354: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS

3350: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3351: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3352: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3353:
3354: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
3355: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3356: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3357:
3358: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID

Line 3402: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,

3398: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3399: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3400:
3401: CURSOR ego_item_assigned_org_csr (
3402: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3403: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3404: IS
3405: SELECT ORGANIZATION_ID
3406: FROM MTL_SYSTEM_ITEMS_VL

Line 3403: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)

3399: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3400:
3401: CURSOR ego_item_assigned_org_csr (
3402: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3403: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3404: IS
3405: SELECT ORGANIZATION_ID
3406: FROM MTL_SYSTEM_ITEMS_VL
3407: WHERE INVENTORY_ITEM_ID = v_inventory_item_id

Line 3430: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL

3426: L_MASTER_ORGANIZATION_ID := EGO_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
3427:
3428: IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
3429: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3430: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3431: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3432:
3433: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
3434: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 3433: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL

3429: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3430: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3431: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3432:
3433: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
3434: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3435: ELSE
3436: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3437:

Line 3469: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

3465: P_ITEM_STATUS);
3466:
3467: IF (L_CONTROL_LEVEL = 2) THEN
3468: -- Org Control
3469: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3470: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3471: AND ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID;
3472:
3473: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 3473: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

3469: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3470: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3471: AND ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID;
3472:
3473: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3474: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3475: AND ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID;
3476:
3477: OPEN ego_item_assigned_org_csr

Line 3513: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

3509: END LOOP;
3510: CLOSE ego_item_assigned_org_csr;
3511: ELSE
3512: -- Master Control
3513: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3514: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3515:
3516: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3517: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 3516: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

3512: -- Master Control
3513: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3514: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3515:
3516: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3517: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3518:
3519: OPEN ego_item_assigned_org_csr
3520: (v_inventory_item_id => P_INVENTORY_ITEM_ID,

Line 3684: l_sql := 'SELECT COUNT(1) FROM mtl_system_items_b a ' ||

3680: END IF;
3681: END LOOP;
3682:
3683: IF l_str_cat_id IS NULL THEN
3684: l_sql := 'SELECT COUNT(1) FROM mtl_system_items_b a ' ||
3685: 'WHERE a.organization_id = ' || p_organization_id;
3686: ELSE
3687: l_sql := 'SELECT COUNT(1) FROM mtl_system_items_b a ' ||
3688: 'WHERE a.organization_id = ' || p_organization_id ||

Line 3687: l_sql := 'SELECT COUNT(1) FROM mtl_system_items_b a ' ||

3683: IF l_str_cat_id IS NULL THEN
3684: l_sql := 'SELECT COUNT(1) FROM mtl_system_items_b a ' ||
3685: 'WHERE a.organization_id = ' || p_organization_id;
3686: ELSE
3687: l_sql := 'SELECT COUNT(1) FROM mtl_system_items_b a ' ||
3688: 'WHERE a.organization_id = ' || p_organization_id ||
3689: ' AND item_catalog_group_id in (' || l_str_cat_id || ')';
3690: END IF;
3691:

Line 3910: ' FROM mtl_system_items_b ' ||

3906: -- ENG exists
3907: -- check for policy control
3908: l_dynamic_sql :=
3909: ' SELECT item_catalog_group_id, lifecycle_id, current_phase_id' ||
3910: ' FROM mtl_system_items_b ' ||
3911: ' WHERE inventory_item_id = :1' ||
3912: ' AND organization_id = :2';
3913: EXECUTE IMMEDIATE l_dynamic_sql
3914: INTO l_catalog_category_id, l_lifecycle_id, l_current_phase_id

Line 4381: FROM MTL_SYSTEM_ITEMS_B_KFV

4377: BEGIN
4378: IF p_inventory_item_id IS NULL THEN
4379: IF p_item_number IS NOT NULL THEN
4380: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4381: FROM MTL_SYSTEM_ITEMS_B_KFV
4382: WHERE ORGANIZATION_ID = l_organization_id
4383: AND CONCATENATED_SEGMENTS = p_item_number;
4384: ELSE
4385: RAISE INVALID_ITEM;

Line 4389: FROM MTL_SYSTEM_ITEMS_B_KFV

4385: RAISE INVALID_ITEM;
4386: END IF;
4387: ELSE
4388: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4389: FROM MTL_SYSTEM_ITEMS_B_KFV
4390: WHERE ORGANIZATION_ID = l_organization_id
4391: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4392: END IF;
4393: