DBA Data[Home] [Help]

APPS.INVPULI4 dependencies on MTL_PARAMETERS

Line 76: from MTL_PARAMETERS

72: B.PROCESS_EXECUTION_ENABLED_FLAG
73: FROM MTL_SYSTEM_ITEMS B
74: WHERE B.INVENTORY_ITEM_ID = item_id
75: AND B.ORGANIZATION_ID = nvl(master_org_id,(select MASTER_ORGANIZATION_ID
76: from MTL_PARAMETERS
77: where ORGANIZATION_ID = org_id));
78: /* Fix for bug 4670905 - Added below cursor to fetch the status attribute values of an exisitng item.*/
79: CURSOR org_cur is
80: select B.STOCK_ENABLED_FLAG,B.PURCHASING_ENABLED_FLAG,

Line 119: FROM MTL_PARAMETERS

115: Master_Org := 'N';
116:
117: begin
118: SELECT 'Y' INTO Master_Org
119: FROM MTL_PARAMETERS
120: WHERE ORGANIZATION_ID = master_organization_id
121: AND ORGANIZATION_ID = org_id;
122: EXCEPTION
123: WHEN NO_DATA_FOUND THEN