DBA Data[Home] [Help]

APPS.INVPULI4 dependencies on MTL_PARAMETERS

Line 73: ,MTL_PARAMETERS PARAM

69: B.INVOICE_ENABLED_FLAG,
70: B.RECIPE_ENABLED_FLAG,
71: B.PROCESS_EXECUTION_ENABLED_FLAG
72: FROM MTL_SYSTEM_ITEMS B
73: ,MTL_PARAMETERS PARAM
74: WHERE B.INVENTORY_ITEM_ID = item_id
75: AND B.ORGANIZATION_ID = PARAM.MASTER_ORGANIZATION_ID
76: AND PARAM.ORGANIZATION_ID = org_id;
77:

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