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

Line 43: FROM mtl_system_items_b

39: ( p_inventory_item_id NUMBER
40: , p_organization_id NUMBER
41: ) IS
42: SELECT 'x'
43: FROM mtl_system_items_b
44: WHERE
45: inventory_item_id = p_inventory_item_id
46: AND organization_id = p_organization_id;
47:

Line 92: FROM mtl_system_items_b

88:
89: CURSOR c_copy_item_info (cp_inventory_item_id IN NUMBER
90: ,cp_organization_id IN NUMBER ) IS
91: SELECT *
92: FROM mtl_system_items_b
93: WHERE inventory_item_id = cp_inventory_item_id
94: AND organization_id = cp_organization_id;
95:
96: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

Line 96: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

92: FROM mtl_system_items_b
93: WHERE inventory_item_id = cp_inventory_item_id
94: AND organization_id = cp_organization_id;
95:
96: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
97:
98: BEGIN
99: developer_debug ('::2960442::initialize_item_info::start');
100: OPEN c_copy_item_info (cp_inventory_item_id => p_inventory_item_id

Line 481: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',

477: WHERE NVL(a.status_control_code, 3) <> 1
478: AND a.control_level IN (1, 2)
479: AND a.attribute_group_id_gui IS NOT NULL
480: AND a.attribute_name NOT IN
481: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
482: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
483: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
484: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
485: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',

Line 484: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',

480: AND a.attribute_name NOT IN
481: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
482: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
483: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
484: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
485: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
486: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
487: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
488: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',

Line 508: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',

504: WHERE NVL(a.status_control_code, 3) <> 1
505: AND a.control_level IN (1, 2)
506: AND a.attribute_group_id_gui IS NOT NULL
507: AND a.attribute_name IN
508: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
509: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
510: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
511: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
512: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',

Line 511: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',

507: AND a.attribute_name IN
508: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
509: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
510: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
511: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
512: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
513: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
514: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
515: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',

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

595: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
596: g_in_item_tbl(0).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
597: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
598: g_in_item_tbl(0).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
599: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
600: g_in_item_tbl(0).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
601: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
602: g_in_item_tbl(0).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
603: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

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

597: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
598: g_in_item_tbl(0).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
599: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
600: g_in_item_tbl(0).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
601: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
602: g_in_item_tbl(0).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
603: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
604: g_in_item_tbl(0).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
605: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN

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

599: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
600: g_in_item_tbl(0).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
601: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
602: g_in_item_tbl(0).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
603: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
604: g_in_item_tbl(0).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
605: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
606: g_in_item_tbl(0).BUYER_ID := cr.ATTRIBUTE_VALUE;
607: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN

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

601: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
602: g_in_item_tbl(0).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
603: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
604: g_in_item_tbl(0).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
605: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
606: g_in_item_tbl(0).BUYER_ID := cr.ATTRIBUTE_VALUE;
607: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
608: g_in_item_tbl(0).CARRYING_COST := cr.ATTRIBUTE_VALUE;
609: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN

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

921: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
922: g_in_item_tbl(0).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
923: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
924: g_in_item_tbl(0).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
925: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
926: g_in_item_tbl(0).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
927: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
928: g_in_item_tbl(0).WEB_STATUS := cr.ATTRIBUTE_VALUE;
929: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN

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

935: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
936: g_in_item_tbl(0).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
937: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
938: g_in_item_tbl(0).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
939: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
940: g_in_item_tbl(0).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
941: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
942: g_in_item_tbl(0).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
943: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN

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

1020:
1021: IF ( (l_org_id is NOT NULL) AND (l_org_id = p_organization_id) ) THEN
1022: FOR cr IN c_get_org_template_attributes (cp_template_id => p_template_id) LOOP
1023: developer_debug(' Setting ORG template Attribute Name ' || cr.attribute_name || ' attribute value ' || cr.attribute_value );
1024: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
1025: g_in_item_tbl(0).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
1026: -- ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' THEN
1027: -- g_in_item_tbl(0).BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;
1028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN

Line 1026: -- ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' THEN

1022: FOR cr IN c_get_org_template_attributes (cp_template_id => p_template_id) LOOP
1023: developer_debug(' Setting ORG template Attribute Name ' || cr.attribute_name || ' attribute value ' || cr.attribute_value );
1024: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
1025: g_in_item_tbl(0).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
1026: -- ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' THEN
1027: -- g_in_item_tbl(0).BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;
1028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
1029: g_in_item_tbl(0).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
1030: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN

Line 1185: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

1181: developer_debug ('::2960442::Create_Item_Lifecycle::start');
1182: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1183: X_MSG_COUNT := 0;
1184:
1185: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1186: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1187: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1188:
1189: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 1189: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

1185: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1186: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1187: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1188:
1189: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
1190: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1191: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1192:
1193: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS

Line 1193: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS

1189: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
1190: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1191: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1192:
1193: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
1194: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1195: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1196:
1197: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID

Line 1238: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,

1234: )
1235: IS
1236: CURSOR ego_item_assigned_org_csr
1237: (
1238: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
1239: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
1240: ) IS
1241: SELECT ORGANIZATION_ID
1242: FROM MTL_SYSTEM_ITEMS_VL

Line 1239: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE

1235: IS
1236: CURSOR ego_item_assigned_org_csr
1237: (
1238: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
1239: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
1240: ) IS
1241: SELECT ORGANIZATION_ID
1242: FROM MTL_SYSTEM_ITEMS_VL
1243: WHERE INVENTORY_ITEM_ID = v_inventory_item_id

Line 1264: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL

1260: L_MASTER_ORGANIZATION_ID := EGO_UI_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
1261:
1262: IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
1263: IF (P_CATALOG_GROUP_ID IS NULL) THEN
1264: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
1265: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1266:
1267: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
1268: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 1267: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL

1263: IF (P_CATALOG_GROUP_ID IS NULL) THEN
1264: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
1265: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1266:
1267: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
1268: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1269: ELSE
1270: L_CONTROL_LEVEL := EGO_UI_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
1271:

Line 1307: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

1303: );
1304:
1305: IF (L_CONTROL_LEVEL = 2) THEN
1306: -- Org Control
1307: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1308: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1309: AND ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID;
1310:
1311: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

Line 1311: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

1307: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1308: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1309: AND ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID;
1310:
1311: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
1312: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1313: AND ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID;
1314:
1315: OPEN ego_item_assigned_org_csr (v_inventory_item_id => P_INVENTORY_ITEM_ID,

Line 1354: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID

1350: END LOOP;
1351: CLOSE ego_item_assigned_org_csr;
1352: ELSE
1353: -- Master Control
1354: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1355: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1356:
1357: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
1358: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 1357: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID

1353: -- Master Control
1354: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1355: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1356:
1357: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
1358: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1359:
1360: OPEN ego_item_assigned_org_csr (v_inventory_item_id => P_INVENTORY_ITEM_ID,
1361: v_master_organization_id => L_MASTER_ORGANIZATION_ID);

Line 2193: from mtl_system_items_b a

2189:
2190: BEGIN
2191: IF(p_item_type IS NOT NULL) THEN
2192: select count(*) INTO l_total_count
2193: from mtl_system_items_b a
2194: where item_catalog_group_id
2195: in(
2196: select item_catalog_group_id
2197: from mtl_item_catalog_groups_b b

Line 2205: from mtl_system_items_b a

2201: and a.organization_id = p_organization_id
2202: and a.eng_item_flag = p_item_type;
2203: ELSE
2204: select count(*) INTO l_total_count
2205: from mtl_system_items_b a
2206: where item_catalog_group_id
2207: in(
2208: select item_catalog_group_id
2209: from mtl_item_catalog_groups_b b

Line 2248: from mtl_item_categories a , mtl_system_items_b b

2244: BEGIN
2245: IF (P_CATEGORY_ID <> -1) THEN
2246: IF(P_ITEM_TYPE IS NOT NULL) THEN
2247: select count(*) into l_total_count
2248: from mtl_item_categories a , mtl_system_items_b b
2249: where category_id in (
2250: select category_id
2251: from mtl_category_set_valid_cats
2252: start with category_id = P_CATEGORY_ID

Line 2264: from mtl_item_categories a , mtl_system_items_b b

2260: and a.organization_id = b.organization_id
2261: and b.eng_item_flag = P_ITEM_TYPE;
2262: ELSE
2263: select count(*) into l_total_count
2264: from mtl_item_categories a , mtl_system_items_b b
2265: where category_id in (
2266: select category_id
2267: from mtl_category_set_valid_cats
2268: start with category_id = P_CATEGORY_ID

Line 2281: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c

2277: END IF;
2278: ELSE
2279: IF(P_ITEM_TYPE IS NOT NULL) THEN
2280: select count(*) into l_total_count
2281: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c
2282: where a.organization_id = P_ORGANIZATION_ID
2283: and a.category_set_id = P_CATEGORY_SET_ID
2284: and c.category_set_id = P_CATEGORY_SET_ID
2285: and c.category_id = a.category_id

Line 2291: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c

2287: and a.organization_id = b.organization_id
2288: and b.eng_item_flag = P_ITEM_TYPE;
2289: ELSE
2290: select count(*) into l_total_count
2291: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c
2292: where a.organization_id = P_ORGANIZATION_ID
2293: and a.category_set_id = P_CATEGORY_SET_ID
2294: and c.category_set_id = P_CATEGORY_SET_ID
2295: and c.category_id = a.category_id