DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MTL_PARAMETERS

Line 1271: MTL_PARAMETERS

1267: NVL(PROCESS_ENABLED_FLAG
1268: ,'N')
1269: INTO C_PROCESS_ENABLED
1270: FROM
1271: MTL_PARAMETERS
1272: WHERE ORGANIZATION_ID = ORG_ID;
1273: IF C_PROCESS_ENABLED <> 'Y' THEN
1274: SELECT
1275: DECODE(NVL(CST.ITEM_COST

Line 1331: MTL_PARAMETERS PARAM

1327: ,(FC_QTY * 12))
1328: INTO ANNUAL_DEMAND
1329: FROM
1330: BOM_CALENDARS CAL,
1331: MTL_PARAMETERS PARAM
1332: WHERE PARAM.ORGANIZATION_ID = ORG_ID
1333: AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE;
1334: SELECT
1335: SQRT(2 * ANNUAL_DEMAND * COST_RATIO)

Line 1553: MTL_PARAMETERS

1549: NVL(PROCESS_ENABLED_FLAG
1550: ,'N')
1551: INTO C_PROCESS_ENABLED
1552: FROM
1553: MTL_PARAMETERS
1554: WHERE ORGANIZATION_ID = ORG_ID;
1555: IF C_PROCESS_ENABLED = 'Y' THEN
1556: SELECT
1557: SUM((NVL((NVL(D.WIP_PLAN_QTY

Line 1811: MTL_PARAMETERS

1807: NVL(PROCESS_ENABLED_FLAG
1808: ,'N')
1809: INTO C_PROCESS_ENABLED
1810: FROM
1811: MTL_PARAMETERS
1812: WHERE ORGANIZATION_ID = ORG_ID;
1813: IF C_PROCESS_ENABLED = 'Y' THEN
1814: SELECT
1815: SUM(NVL((NVL(D.WIP_PLAN_QTY