APPS.INV_ITEM_STATUS_CP dependencies on MTL_SYSTEM_ITEMS_B

Line 9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';

5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13: G_PKG_NAME VARCHAR2(50) := 'INV_ITEM_STATUS_CP';

Line 12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';

8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13: G_PKG_NAME VARCHAR2(50) := 'INV_ITEM_STATUS_CP';
14:
15: G_ITEM NUMBER := 1;
16: G_ITEM_ORG NUMBER := 2;

Line 64: from mtl_system_items_b table.

60:
61: IS
62: /* Start Bug#7454766
63: Declaring Cursor c_get_values_from_msib to fetch values of INVENTORY_ITEM_STATUS_CODE, INTERNAL_ORDER_ENABLED_FLAG, PURCHASING_ENABLED_FLAG,
64: from mtl_system_items_b table.
65: */
66:
67: CURSOR c_get_values_from_msib (p_item_id number,p_org_id number)
68: IS

Line 70: FROM mtl_system_items_b msib

66:
67: CURSOR c_get_values_from_msib (p_item_id number,p_org_id number)
68: IS
69: SELECT INVENTORY_ITEM_STATUS_CODE, INTERNAL_ORDER_ENABLED_FLAG, PURCHASING_ENABLED_FLAG
70: FROM mtl_system_items_b msib
71: WHERE msib.inventory_item_id = p_Item_Id
72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;

Line 74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;

70: FROM mtl_system_items_b msib
71: WHERE msib.inventory_item_id = p_Item_Id
72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;
75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;
76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;
77:
78: /* End Bug#7454766 */

Line 75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;

71: WHERE msib.inventory_item_id = p_Item_Id
72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;
75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;
76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;
77:
78: /* End Bug#7454766 */
79:

Line 76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;

72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;
75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;
76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;
77:
78: /* End Bug#7454766 */
79:
80:

Line 184: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

180: end if;
181: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
182: SELECT count(*) INTO is_bom_enabled_upd
183: FROM mtl_status_attribute_values
184: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
185: AND attribute_value = 'N'
186: AND inventory_item_status_code = p_pending_status;
187:
188: /*commented for bug 5479302

Line 219: FROM mtl_system_items_b msi

215: Sum(Decode(mav.attribute_name,G_CUSTOMER_ENABLED ,Decode(mav.attribute_value,'N',Decode(msi.orderable_on_web_flag,'Y',1,0),0),0)) uncheck_orderable_err
216: INTO G_TRANSACTABLE
217: ,G_PURCHASABLE
218: ,G_ORDERABLE
219: FROM mtl_system_items_b msi
220: ,mtl_status_attribute_values mav
221: WHERE msi.inventory_item_id = p_Item_Id
222: AND msi.organization_id = p_Org_Id
223: AND mav.inventory_item_status_code = p_pending_status