APPS.MSC_ATP_ALLOC dependencies on MSC_AATP_FUNC

Line 1117: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1113: DECODE(decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
1114: 6, decode(d.source_organization_id,
1115: NULL, DECODE(D.DEMAND_CLASS, null, null,
1116: DECODE(TEMP.DEMAND_CLASS, '-1',
1117: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1118: null, null, l_item_to_use, p_organization_id,
1119: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1120: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1121: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1127: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1123: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1124: D.DEMAND_CLASS)),
1125: -23453, DECODE(D.DEMAND_CLASS, null, null,
1126: DECODE(TEMP.DEMAND_CLASS, '-1',
1127: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1128: null, null, l_item_to_use, p_organization_id,
1129: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1130: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1131: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1137: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1133: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1134: D.DEMAND_CLASS)),
1135: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1136: DECODE(TEMP.DEMAND_CLASS, '-1',
1137: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1138: null, null, l_item_to_use, p_organization_id,
1139: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1140: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1141: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1148: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1144: D.DEMAND_CLASS)), NULL),
1145: 30, decode(d.source_organization_id,
1146: NULL, DECODE(D.DEMAND_CLASS, null, null,
1147: DECODE(TEMP.DEMAND_CLASS, '-1',
1148: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1149: null, null, l_item_to_use, p_organization_id,
1150: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1151: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1152: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1158: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1154: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1155: D.DEMAND_CLASS)),
1156: -23453, DECODE(D.DEMAND_CLASS, null, null,
1157: DECODE(TEMP.DEMAND_CLASS, '-1',
1158: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1159: null, null, l_item_to_use, p_organization_id,
1160: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1161: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1162: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1168: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1164: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1165: D.DEMAND_CLASS)),
1166: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1167: DECODE(TEMP.DEMAND_CLASS, '-1',
1168: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1169: null, null, l_item_to_use, p_organization_id,
1170: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1171: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1172: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1178: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1174: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1175: D.DEMAND_CLASS)), NULL),
1176: DECODE(D.DEMAND_CLASS, null, null,
1177: DECODE(TEMP.DEMAND_CLASS, '-1',
1178: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1179: null, null, l_item_to_use, p_organization_id,
1180: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1181: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1182: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1187: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

1183: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
1184: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1185: D.DEMAND_CLASS))),
1186: TEMP.DEMAND_CLASS, 1,
1187: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
1188: D.DEMAND_ID,
1189: TRUNC(DECODE(D.RECORD_SOURCE,
1190: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1191: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1207: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1203: decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
1204: 6, decode(d.source_organization_id,
1205: NULL, DECODE(D.DEMAND_CLASS, null, null,
1206: DECODE(TEMP.DEMAND_CLASS, '-1',
1207: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1208: null, null, l_item_to_use, p_organization_id,
1209: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1210: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1211: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1217: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1213: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1214: D.DEMAND_CLASS)),
1215: -23453, DECODE(D.DEMAND_CLASS, null, null,
1216: DECODE(TEMP.DEMAND_CLASS, '-1',
1217: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1218: null, null, l_item_to_use, p_organization_id,
1219: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1220: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1221: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1227: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1223: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1224: D.DEMAND_CLASS)),
1225: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1226: DECODE(TEMP.DEMAND_CLASS, '-1',
1227: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1228: null, null, l_item_to_use, p_organization_id,
1229: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1230: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1231: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1238: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1234: D.DEMAND_CLASS)), TEMP.DEMAND_CLASS),
1235: 30, decode(d.source_organization_id,
1236: NULL, DECODE(D.DEMAND_CLASS, null, null,
1237: DECODE(TEMP.DEMAND_CLASS, '-1',
1238: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1239: null, null, l_item_to_use, p_organization_id,
1240: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1241: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1242: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1248: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1244: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1245: D.DEMAND_CLASS)),
1246: -23453, DECODE(D.DEMAND_CLASS, null, null,
1247: DECODE(TEMP.DEMAND_CLASS, '-1',
1248: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1249: null, null, l_item_to_use, p_organization_id,
1250: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1251: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1252: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1258: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1254: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1255: D.DEMAND_CLASS)),
1256: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1257: DECODE(TEMP.DEMAND_CLASS, '-1',
1258: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1259: null, null, l_item_to_use, p_organization_id,
1260: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1261: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1262: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1268: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1264: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))), l_level_id, D.DEMAND_CLASS),
1265: D.DEMAND_CLASS)), TEMP.DEMAND_CLASS),
1266: DECODE(D.DEMAND_CLASS, null, null,
1267: DECODE(TEMP.DEMAND_CLASS, '-1',
1268: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1269: null, null, l_item_to_use, p_organization_id,
1270: p_instance_id, /*c.prior_date,*/ TRUNC(DECODE(D.RECORD_SOURCE,
1271: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1272: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 1367: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1363: NVL(S.FIRM_QUANTITY,
1364: S.NEW_ORDER_QUANTITY)
1365: * DECODE(DECODE(S.DEMAND_CLASS, null, null,
1366: DECODE(TEMP.DEMAND_CLASS,'-1',
1367: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1368: null,
1369: null,
1370: l_item_to_use,
1371: p_organization_id,

Line 1381: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1377: S.DEMAND_CLASS), S.DEMAND_CLASS)),
1378: TEMP.DEMAND_CLASS,
1379: 1,
1380: NULL,
1381: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1382: p_instance_id,
1383: S.inventory_item_id,
1384: p_organization_id,
1385: null,

Line 1392: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1388: -- Bug 3823042
1389: --c.next_date,
1390: TRUNC(NVL(S.FIRM_DATE, S.NEW_SCHEDULE_DATE))),
1391: 1),
1392: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1393: p_instance_id,
1394: S.inventory_item_id,
1395: p_organization_id,
1396: null,

Line 1489: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1485: DECODE(decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
1486: 6, decode(d.source_organization_id,
1487: NULL, DECODE(D.DEMAND_CLASS, null, null,
1488: DECODE(TEMP.DEMAND_CLASS, '-1',
1489: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1490: null, null, l_item_to_use, p_organization_id,
1491: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1492: D.DEMAND_CLASS)),
1493: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1495: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1491: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1492: D.DEMAND_CLASS)),
1493: -23453, DECODE(D.DEMAND_CLASS, null, null,
1494: DECODE(TEMP.DEMAND_CLASS, '-1',
1495: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1496: null, null, l_item_to_use, p_organization_id,
1497: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1498: D.DEMAND_CLASS)),
1499: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1501: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1497: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1498: D.DEMAND_CLASS)),
1499: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1500: DECODE(TEMP.DEMAND_CLASS, '-1',
1501: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1502: null, null, l_item_to_use, p_organization_id,
1503: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1504: D.DEMAND_CLASS)), NULL),
1505: 30, decode(d.source_organization_id,

Line 1508: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1504: D.DEMAND_CLASS)), NULL),
1505: 30, decode(d.source_organization_id,
1506: NULL, DECODE(D.DEMAND_CLASS, null, null,
1507: DECODE(TEMP.DEMAND_CLASS, '-1',
1508: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1509: null, null, l_item_to_use, p_organization_id,
1510: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1511: D.DEMAND_CLASS)),
1512: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1514: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1510: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1511: D.DEMAND_CLASS)),
1512: -23453, DECODE(D.DEMAND_CLASS, null, null,
1513: DECODE(TEMP.DEMAND_CLASS, '-1',
1514: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1515: null, null, l_item_to_use, p_organization_id,
1516: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1517: D.DEMAND_CLASS)),
1518: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1520: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1516: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1517: D.DEMAND_CLASS)),
1518: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1519: DECODE(TEMP.DEMAND_CLASS, '-1',
1520: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1521: null, null, l_item_to_use, p_organization_id,
1522: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1523: D.DEMAND_CLASS)), NULL),
1524: DECODE(D.DEMAND_CLASS, null, null,

Line 1526: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1522: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1523: D.DEMAND_CLASS)), NULL),
1524: DECODE(D.DEMAND_CLASS, null, null,
1525: DECODE(TEMP.DEMAND_CLASS, '-1',
1526: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1527: null, null, l_item_to_use, p_organization_id,
1528: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1529: D.DEMAND_CLASS))),
1530: TEMP.DEMAND_CLASS, 1,

Line 1531: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

1527: null, null, l_item_to_use, p_organization_id,
1528: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1529: D.DEMAND_CLASS))),
1530: TEMP.DEMAND_CLASS, 1,
1531: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
1532: D.DEMAND_ID,
1533: C.CALENDAR_DATE,
1534: D.USING_ASSEMBLY_ITEM_ID,
1535: DECODE(D.SOURCE_ORGANIZATION_ID,

Line 1546: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1542: decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
1543: 6, decode(d.source_organization_id,
1544: NULL, DECODE(D.DEMAND_CLASS, null, null,
1545: DECODE(TEMP.DEMAND_CLASS, '-1',
1546: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1547: null, null, l_item_to_use, p_organization_id,
1548: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1549: D.DEMAND_CLASS)),
1550: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1552: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1548: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1549: D.DEMAND_CLASS)),
1550: -23453, DECODE(D.DEMAND_CLASS, null, null,
1551: DECODE(TEMP.DEMAND_CLASS, '-1',
1552: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1553: null, null, l_item_to_use, p_organization_id,
1554: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1555: D.DEMAND_CLASS)),
1556: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1558: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1554: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1555: D.DEMAND_CLASS)),
1556: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1557: DECODE(TEMP.DEMAND_CLASS, '-1',
1558: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1559: null, null, l_item_to_use, p_organization_id,
1560: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1561: D.DEMAND_CLASS)), TEMP.DEMAND_CLASS),
1562: 30, decode(d.source_organization_id,

Line 1565: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1561: D.DEMAND_CLASS)), TEMP.DEMAND_CLASS),
1562: 30, decode(d.source_organization_id,
1563: NULL, DECODE(D.DEMAND_CLASS, null, null,
1564: DECODE(TEMP.DEMAND_CLASS, '-1',
1565: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1566: null, null, l_item_to_use, p_organization_id,
1567: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1568: D.DEMAND_CLASS)),
1569: -23453, DECODE(D.DEMAND_CLASS, null, null,

Line 1571: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1567: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1568: D.DEMAND_CLASS)),
1569: -23453, DECODE(D.DEMAND_CLASS, null, null,
1570: DECODE(TEMP.DEMAND_CLASS, '-1',
1571: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1572: null, null, l_item_to_use, p_organization_id,
1573: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1574: D.DEMAND_CLASS)),
1575: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,

Line 1577: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1573: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1574: D.DEMAND_CLASS)),
1575: d.organization_id, DECODE(D.DEMAND_CLASS, null, null,
1576: DECODE(TEMP.DEMAND_CLASS, '-1',
1577: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1578: null, null, l_item_to_use, p_organization_id,
1579: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1580: D.DEMAND_CLASS)), TEMP.DEMAND_CLASS),
1581: DECODE(D.DEMAND_CLASS, null, null,

Line 1583: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1579: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1580: D.DEMAND_CLASS)), TEMP.DEMAND_CLASS),
1581: DECODE(D.DEMAND_CLASS, null, null,
1582: DECODE(TEMP.DEMAND_CLASS, '-1',
1583: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1584: null, null, l_item_to_use, p_organization_id,
1585: p_instance_id, C.CALENDAR_DATE, l_level_id, D.DEMAND_CLASS),
1586: D.DEMAND_CLASS))),
1587: TEMP.DEMAND_CLASS,

Line 1667: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

1663: NVL(S.FIRM_QUANTITY,
1664: S.NEW_ORDER_QUANTITY)
1665: * DECODE(DECODE(S.DEMAND_CLASS, null, null,
1666: DECODE(TEMP.DEMAND_CLASS,'-1',
1667: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
1668: null,
1669: null,
1670: l_item_to_use,
1671: p_organization_id,

Line 1679: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1675: S.DEMAND_CLASS), S.DEMAND_CLASS)),
1676: TEMP.DEMAND_CLASS,
1677: 1,
1678: NULL,
1679: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1680: p_instance_id,
1681: S.inventory_item_id,
1682: p_organization_id,
1683: null,

Line 1687: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

1683: null,
1684: null,
1685: TEMP.DEMAND_CLASS,
1686: c.calendar_date), 1),
1687: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
1688: p_instance_id,
1689: S.inventory_item_id,
1690: p_organization_id,
1691: null,

Line 2103: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2099: DECODE(DECODE(D.CUSTOMER_ID, NULL, NULL,
2100: 0, NULL,
2101: decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
2102: 6, decode(d.source_organization_id,
2103: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2104: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2105: p_organization_id, p_instance_id, /*c.prior_date, */
2106: TRUNC(DECODE(D.RECORD_SOURCE,
2107: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2112: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2108: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2109: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2110: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2111: l_level_id, NULL),
2112: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2113: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2114: p_organization_id, p_instance_id, /*c.prior_date,*/
2115: TRUNC(DECODE(D.RECORD_SOURCE,
2116: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2121: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2117: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2118: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2119: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2120: l_level_id, NULL),
2121: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2122: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2123: p_organization_id, p_instance_id, /*c.prior_date,*/
2124: TRUNC(DECODE(D.RECORD_SOURCE,
2125: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2132: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2128: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2129: l_level_id, NULL),
2130: NULL),
2131: 30, decode(d.source_organization_id,
2132: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2133: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2134: p_organization_id, p_instance_id, /*c.prior_date, */
2135: TRUNC(DECODE(D.RECORD_SOURCE,
2136: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2141: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2137: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2138: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2139: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2140: l_level_id, NULL),
2141: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2142: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2143: p_organization_id, p_instance_id, /*c.prior_date,*/
2144: TRUNC(DECODE(D.RECORD_SOURCE,
2145: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2150: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2146: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2147: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2148: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2149: l_level_id, NULL),
2150: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2151: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2152: p_organization_id, p_instance_id, /*c.prior_date,*/
2153: TRUNC(DECODE(D.RECORD_SOURCE,
2154: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2160: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2156: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2157: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2158: l_level_id, NULL),
2159: NULL),
2160: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2161: l_item_to_use, p_organization_id, p_instance_id, /*c.prior_date*/
2162: TRUNC(DECODE(D.RECORD_SOURCE,
2163: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2164: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2169: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

2165: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2166: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2167: l_level_id, NULL))),
2168: TEMP.LEVEL_3_DEMAND_CLASS, 1,
2169: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
2170: D.DEMAND_ID,
2171: --c.prior_date,
2172: TRUNC(DECODE(D.RECORD_SOURCE,
2173: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2189: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2185: DECODE(D.CUSTOMER_ID, NULL, TEMP.LEVEL_3_DEMAND_CLASS,
2186: 0, TEMP.LEVEL_3_DEMAND_CLASS,
2187: decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
2188: 6, decode(d.source_organization_id,
2189: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2190: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2191: p_organization_id, p_instance_id, /*c.prior_date, */
2192: TRUNC(DECODE(D.RECORD_SOURCE,
2193: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2198: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2194: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2195: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2196: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2197: l_level_id, NULL),
2198: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2199: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2200: p_organization_id, p_instance_id, /*c.prior_date, */
2201: TRUNC(DECODE(D.RECORD_SOURCE,
2202: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2207: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2203: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2204: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2205: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2206: l_level_id, NULL),
2207: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2208: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2209: p_organization_id, p_instance_id, /*c.prior_date, */
2210: TRUNC(DECODE(D.RECORD_SOURCE,
2211: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2218: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2214: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2215: l_level_id, NULL),
2216: TEMP.LEVEL_3_DEMAND_CLASS),
2217: 30, decode(d.source_organization_id,
2218: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2219: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2220: p_organization_id, p_instance_id, /*c.prior_date, */
2221: TRUNC(DECODE(D.RECORD_SOURCE,
2222: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2227: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2223: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2224: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2225: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2226: l_level_id, NULL),
2227: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2228: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2229: p_organization_id, p_instance_id, /*c.prior_date, */
2230: TRUNC(DECODE(D.RECORD_SOURCE,
2231: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2236: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2232: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2233: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2234: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2235: l_level_id, NULL),
2236: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2237: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2238: p_organization_id, p_instance_id, /*c.prior_date,*/
2239: TRUNC(DECODE(D.RECORD_SOURCE,
2240: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),

Line 2246: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2242: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
2243: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),
2244: l_level_id, NULL),
2245: TEMP.LEVEL_3_DEMAND_CLASS),
2246: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2247: l_item_to_use, p_organization_id, p_instance_id, /*c.prior_date,*/
2248: TRUNC(DECODE(D.RECORD_SOURCE,
2249: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2250: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 2347: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2343: S.ORDER_TYPE col10, -- supply_demand_source_type
2344: NVL(S.FIRM_QUANTITY,
2345: S.NEW_ORDER_QUANTITY)
2346: * DECODE(DECODE(S.CUSTOMER_ID, NULL, NULL,
2347: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2348: S.CUSTOMER_ID,
2349: S.SHIP_TO_SITE_ID,
2350: l_item_to_use,
2351: p_organization_id,

Line 2360: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2356: NULL)),
2357: TEMP.LEVEL_3_DEMAND_CLASS,
2358: 1,
2359: NULL,
2360: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2361: p_instance_id,
2362: S.inventory_item_id,
2363: p_organization_id,
2364: null,

Line 2370: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2366: TEMP.LEVEL_3_DEMAND_CLASS,
2367: --c.next_date),
2368: TRUNC(NVL(S.FIRM_DATE, S.NEW_SCHEDULE_DATE))),
2369: 1),
2370: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2371: p_instance_id,
2372: S.inventory_item_id,
2373: p_organization_id,
2374: null,

Line 2474: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2470: DECODE(DECODE(D.CUSTOMER_ID, NULL, NULL,
2471: 0, NULL,
2472: decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
2473: 6, decode(d.source_organization_id,
2474: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2475: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2476: p_organization_id, p_instance_id, /*c.prior_date,*/
2477: C.CALENDAR_DATE,
2478: l_level_id, NULL),

Line 2479: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2475: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2476: p_organization_id, p_instance_id, /*c.prior_date,*/
2477: C.CALENDAR_DATE,
2478: l_level_id, NULL),
2479: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2480: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2481: p_organization_id, p_instance_id, /*c.prior_date,*/
2482: C.CALENDAR_DATE,
2483: l_level_id, NULL),

Line 2484: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2480: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2481: p_organization_id, p_instance_id, /*c.prior_date,*/
2482: C.CALENDAR_DATE,
2483: l_level_id, NULL),
2484: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2485: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2486: p_organization_id, p_instance_id, /*c.prior_date, */
2487: C.CALENDAR_DATE,
2488: l_level_id, NULL),

Line 2491: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2487: C.CALENDAR_DATE,
2488: l_level_id, NULL),
2489: NULL),
2490: 30, decode(d.source_organization_id,
2491: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2492: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2493: p_organization_id, p_instance_id, /*c.prior_date,*/
2494: C.CALENDAR_DATE,
2495: l_level_id, NULL),

Line 2496: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2492: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2493: p_organization_id, p_instance_id, /*c.prior_date,*/
2494: C.CALENDAR_DATE,
2495: l_level_id, NULL),
2496: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2497: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2498: p_organization_id, p_instance_id, /*c.prior_date,*/
2499: C.CALENDAR_DATE,
2500: l_level_id, NULL),

Line 2501: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2497: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2498: p_organization_id, p_instance_id, /*c.prior_date,*/
2499: C.CALENDAR_DATE,
2500: l_level_id, NULL),
2501: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2502: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2503: p_organization_id, p_instance_id, /*c.prior_date,*/
2504: C.CALENDAR_DATE,
2505: l_level_id, NULL),

Line 2507: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2503: p_organization_id, p_instance_id, /*c.prior_date,*/
2504: C.CALENDAR_DATE,
2505: l_level_id, NULL),
2506: NULL),
2507: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2508: l_item_to_use, p_organization_id, p_instance_id, /*c.prior_date,*/
2509: C.CALENDAR_DATE,
2510: l_level_id, NULL))),
2511: TEMP.LEVEL_3_DEMAND_CLASS, 1,

Line 2512: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,

2508: l_item_to_use, p_organization_id, p_instance_id, /*c.prior_date,*/
2509: C.CALENDAR_DATE,
2510: l_level_id, NULL))),
2511: TEMP.LEVEL_3_DEMAND_CLASS, 1,
2512: MSC_AATP_FUNC.Get_Item_Demand_Alloc_Percent(p_plan_id,
2513: D.DEMAND_ID,
2514: --c.prior_date,
2515: C.CALENDAR_DATE,
2516: D.USING_ASSEMBLY_ITEM_ID,

Line 2528: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2524: DECODE(D.CUSTOMER_ID, NULL, TEMP.LEVEL_3_DEMAND_CLASS,
2525: 0, TEMP.LEVEL_3_DEMAND_CLASS,
2526: decode(decode(D.ORIGINATION_TYPE,-100,30,D.ORIGINATION_TYPE),
2527: 6, decode(d.source_organization_id,
2528: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2529: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2530: p_organization_id, p_instance_id, /*c.prior_date,*/
2531: C.CALENDAR_DATE,
2532: l_level_id, NULL),

Line 2533: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2529: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2530: p_organization_id, p_instance_id, /*c.prior_date,*/
2531: C.CALENDAR_DATE,
2532: l_level_id, NULL),
2533: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2534: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2535: p_organization_id, p_instance_id, /*c.prior_date, */
2536: C.CALENDAR_DATE,
2537: l_level_id, NULL),

Line 2538: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2534: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2535: p_organization_id, p_instance_id, /*c.prior_date, */
2536: C.CALENDAR_DATE,
2537: l_level_id, NULL),
2538: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2539: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2540: p_organization_id, p_instance_id, /*c.prior_date, */
2541: C.CALENDAR_DATE,
2542: l_level_id, NULL),

Line 2545: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2541: C.CALENDAR_DATE,
2542: l_level_id, NULL),
2543: TEMP.LEVEL_3_DEMAND_CLASS),
2544: 30, decode(d.source_organization_id,
2545: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2546: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2547: p_organization_id, p_instance_id, /*c.prior_date,*/
2548: C.CALENDAR_DATE,
2549: l_level_id, NULL),

Line 2550: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2546: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2547: p_organization_id, p_instance_id, /*c.prior_date,*/
2548: C.CALENDAR_DATE,
2549: l_level_id, NULL),
2550: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2551: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2552: p_organization_id, p_instance_id, /*c.prior_date,*/
2553: C.CALENDAR_DATE,
2554: l_level_id, NULL),

Line 2555: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2551: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2552: p_organization_id, p_instance_id, /*c.prior_date,*/
2553: C.CALENDAR_DATE,
2554: l_level_id, NULL),
2555: d.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2556: D.CUSTOMER_ID, D.SHIP_TO_SITE_ID, l_item_to_use,
2557: p_organization_id, p_instance_id, /*c.prior_date,*/
2558: C.CALENDAR_DATE,
2559: l_level_id, NULL),

Line 2561: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,

2557: p_organization_id, p_instance_id, /*c.prior_date,*/
2558: C.CALENDAR_DATE,
2559: l_level_id, NULL),
2560: TEMP.LEVEL_3_DEMAND_CLASS),
2561: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(D.CUSTOMER_ID, D.SHIP_TO_SITE_ID,
2562: l_item_to_use, p_organization_id, p_instance_id, /*c.prior_date,*/
2563: C.CALENDAR_DATE,
2564: l_level_id, NULL))),
2565: TEMP.LEVEL_3_DEMAND_CLASS,

Line 2650: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(

2646: S.ORDER_TYPE col10, -- supply_demand_source_type
2647: NVL(S.FIRM_QUANTITY,
2648: S.NEW_ORDER_QUANTITY)
2649: * DECODE(DECODE(S.CUSTOMER_ID, NULL, NULL,
2650: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
2651: S.CUSTOMER_ID,
2652: S.SHIP_TO_SITE_ID,
2653: l_item_to_use,
2654: p_organization_id,

Line 2663: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2659: NULL)),
2660: TEMP.LEVEL_3_DEMAND_CLASS,
2661: 1,
2662: NULL,
2663: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2664: p_instance_id,
2665: S.inventory_item_id,
2666: p_organization_id,
2667: null,

Line 2673: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

2669: TEMP.LEVEL_3_DEMAND_CLASS,
2670: --c.next_date),
2671: C.CALENDAR_DATE),
2672: 1),
2673: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
2674: p_instance_id,
2675: S.inventory_item_id,
2676: p_organization_id,
2677: null,