APPS.MSC_ATP_PF dependencies on MSC_ATP_ALLOC

Line 6053: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6049: p_org_code col20, -- Organization code
6050: Decode(AD.inventory_item_id, p_family_id,
6051: Decode(AD.original_item_id, p_member_id,
6052: AD.Pf_Display_Flag,
6053: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6054: 1, AD.Pf_Display_Flag,
6055: 1)),
6056: AD.Pf_Display_Flag) col21,
6057: -1 * NVL(AD.DEMAND_QUANTITY,

Line 6191: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6187: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6188: DECODE(TEMP.DEMAND_CLASS, '-1',
6189: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6190: null, null,
6191: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6192: 1, p_family_id,
6193: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6194: 'Y', AD.Original_Item_Id,
6195: p_family_id)),

Line 6204: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6200: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6201: DECODE(TEMP.DEMAND_CLASS, '-1',
6202: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6203: null, null,
6204: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6205: 1, p_family_id,
6206: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6207: 'Y', AD.Original_Item_Id,
6208: p_family_id)),

Line 6217: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6213: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6214: DECODE(TEMP.DEMAND_CLASS, '-1',
6215: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6216: null, null,
6217: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6218: 1, p_family_id,
6219: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6220: 'Y', AD.Original_Item_Id,
6221: p_family_id)),

Line 6231: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6227: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6228: DECODE(TEMP.DEMAND_CLASS, '-1',
6229: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6230: null, null,
6231: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6232: 1, p_family_id,
6233: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6234: 'Y', AD.Original_Item_Id,
6235: p_family_id)),

Line 6244: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6240: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6241: DECODE(TEMP.DEMAND_CLASS, '-1',
6242: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6243: null, null,
6244: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6245: 1, p_family_id,
6246: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6247: 'Y', AD.Original_Item_Id,
6248: p_family_id)),

Line 6257: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6253: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6254: DECODE(TEMP.DEMAND_CLASS, '-1',
6255: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6256: null, null,
6257: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6258: 1, p_family_id,
6259: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6260: 'Y', AD.Original_Item_Id,
6261: p_family_id)),

Line 6270: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6266: DECODE(AD.DEMAND_CLASS, null, null,
6267: DECODE(TEMP.DEMAND_CLASS, '-1',
6268: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6269: null, null,
6270: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6271: 1, p_family_id,
6272: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6273: 'Y', AD.Original_Item_Id,
6274: p_family_id)),

Line 6287: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6283: AD.USING_ASSEMBLY_ITEM_ID,
6284: DECODE(AD.SOURCE_ORGANIZATION_ID,
6285: -23453, null,
6286: AD.SOURCE_ORGANIZATION_ID),
6287: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6288: 1, p_family_id,
6289: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6290: 'Y', AD.Original_Item_Id,
6291: p_family_id)),

Line 6301: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6297: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6298: DECODE(TEMP.DEMAND_CLASS, '-1',
6299: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6300: null, null,
6301: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6302: 1, p_family_id,
6303: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6304: 'Y', AD.Original_Item_Id,
6305: p_family_id)),

Line 6314: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6310: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6311: DECODE(TEMP.DEMAND_CLASS, '-1',
6312: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6313: null, null,
6314: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6315: 1, p_family_id,
6316: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6317: 'Y', AD.Original_Item_Id,
6318: p_family_id)),

Line 6327: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6323: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6324: DECODE(TEMP.DEMAND_CLASS, '-1',
6325: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6326: null, null,
6327: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6328: 1, p_family_id,
6329: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6330: 'Y', AD.Original_Item_Id,
6331: p_family_id)),

Line 6341: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6337: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6338: DECODE(TEMP.DEMAND_CLASS, '-1',
6339: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6340: null, null,
6341: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6342: 1, p_family_id,
6343: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6344: 'Y', AD.Original_Item_Id,
6345: p_family_id)),

Line 6354: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6350: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6351: DECODE(TEMP.DEMAND_CLASS, '-1',
6352: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6353: null, null,
6354: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6355: 1, p_family_id,
6356: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6357: 'Y', AD.Original_Item_Id,
6358: p_family_id)),

Line 6367: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6363: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6364: DECODE(TEMP.DEMAND_CLASS, '-1',
6365: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6366: null, null,
6367: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6368: 1, p_family_id,
6369: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6370: 'Y', AD.Original_Item_Id,
6371: p_family_id)),

Line 6380: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6376: DECODE(AD.DEMAND_CLASS, null, null,
6377: DECODE(TEMP.DEMAND_CLASS, '-1',
6378: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6379: null, null,
6380: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6381: 1, p_family_id,
6382: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6383: 'Y', AD.Original_Item_Id,
6384: p_family_id)),

Line 6407: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6403: p_sr_member_id col21, -- request_item_id
6404: Decode(AD.inventory_item_id, p_family_id,
6405: Decode(AD.original_item_id, p_member_id,
6406: AD.Pf_Display_Flag,
6407: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6408: 1, AD.Pf_Display_Flag,
6409: 1)),
6410: AD.Pf_Display_Flag) col22,
6411: -1 * NVL(AD.DEMAND_QUANTITY,

Line 6419: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6415: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6416: DECODE(TEMP.DEMAND_CLASS, '-1',
6417: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6418: null, null,
6419: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6420: 1, p_family_id,
6421: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6422: 'Y', AD.Original_Item_Id,
6423: p_family_id)),

Line 6432: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6428: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6429: DECODE(TEMP.DEMAND_CLASS, '-1',
6430: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6431: null, null,
6432: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6433: 1, p_family_id,
6434: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6435: 'Y', AD.Original_Item_Id,
6436: p_family_id)),

Line 6445: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6441: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6442: DECODE(TEMP.DEMAND_CLASS, '-1',
6443: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6444: null, null,
6445: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6446: 1, p_family_id,
6447: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6448: 'Y', AD.Original_Item_Id,
6449: p_family_id)),

Line 6459: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6455: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6456: DECODE(TEMP.DEMAND_CLASS, '-1',
6457: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6458: null, null,
6459: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6460: 1, p_family_id,
6461: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6462: 'Y', AD.Original_Item_Id,
6463: p_family_id)),

Line 6472: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6468: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6469: DECODE(TEMP.DEMAND_CLASS, '-1',
6470: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6471: null, null,
6472: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6473: 1, p_family_id,
6474: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6475: 'Y', AD.Original_Item_Id,
6476: p_family_id)),

Line 6485: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6481: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6482: DECODE(TEMP.DEMAND_CLASS, '-1',
6483: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6484: null, null,
6485: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6486: 1, p_family_id,
6487: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6488: 'Y', AD.Original_Item_Id,
6489: p_family_id)),

Line 6498: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6494: DECODE(AD.DEMAND_CLASS, null, null,
6495: DECODE(TEMP.DEMAND_CLASS, '-1',
6496: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6497: null, null,
6498: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6499: 1, p_family_id,
6500: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6501: 'Y', AD.Original_Item_Id,
6502: p_family_id)),

Line 6515: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6511: AD.USING_ASSEMBLY_ITEM_ID,
6512: DECODE(AD.SOURCE_ORGANIZATION_ID,
6513: -23453, null,
6514: AD.SOURCE_ORGANIZATION_ID),
6515: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6516: 1, p_family_id,
6517: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6518: 'Y', AD.Original_Item_Id,
6519: p_family_id)),

Line 6529: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6525: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6526: DECODE(TEMP.DEMAND_CLASS, '-1',
6527: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6528: null, null,
6529: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6530: 1, p_family_id,
6531: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6532: 'Y', AD.Original_Item_Id,
6533: p_family_id)),

Line 6542: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6538: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6539: DECODE(TEMP.DEMAND_CLASS, '-1',
6540: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6541: null, null,
6542: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6543: 1, p_family_id,
6544: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6545: 'Y', AD.Original_Item_Id,
6546: p_family_id)),

Line 6555: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6551: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6552: DECODE(TEMP.DEMAND_CLASS, '-1',
6553: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6554: null, null,
6555: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6556: 1, p_family_id,
6557: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6558: 'Y', AD.Original_Item_Id,
6559: p_family_id)),

Line 6569: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6565: NULL, DECODE(AD.DEMAND_CLASS, null, null,
6566: DECODE(TEMP.DEMAND_CLASS, '-1',
6567: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6568: null, null,
6569: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6570: 1, p_family_id,
6571: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6572: 'Y', AD.Original_Item_Id,
6573: p_family_id)),

Line 6582: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6578: -23453, DECODE(AD.DEMAND_CLASS, null, null,
6579: DECODE(TEMP.DEMAND_CLASS, '-1',
6580: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6581: null, null,
6582: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6583: 1, p_family_id,
6584: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6585: 'Y', AD.Original_Item_Id,
6586: p_family_id)),

Line 6595: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6591: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6592: DECODE(TEMP.DEMAND_CLASS, '-1',
6593: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6594: null, null,
6595: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6596: 1, p_family_id,
6597: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6598: 'Y', AD.Original_Item_Id,
6599: p_family_id)),

Line 6608: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6604: DECODE(AD.DEMAND_CLASS, null, null,
6605: DECODE(TEMP.DEMAND_CLASS, '-1',
6606: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6607: null, null,
6608: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6609: 1, p_family_id,
6610: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6611: 'Y', AD.Original_Item_Id,
6612: p_family_id)),

Line 6669: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6665: DECODE(TEMP.DEMAND_CLASS,'-1',
6666: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6667: null,
6668: null,
6669: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6670: 1, p_family_id,
6671: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6672: 'Y', SA.Original_Item_Id,
6673: p_family_id)),

Line 6685: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6681: 1,
6682: NULL,
6683: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6684: p_instance_id,
6685: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6686: 1, p_family_id,
6687: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6688: 'Y', SA.Original_Item_Id,
6689: p_family_id)),

Line 6698: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6694: TRUNC(SA.SUPPLY_DATE)),
6695: 1),
6696: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6697: p_instance_id,
6698: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6699: 1, p_family_id,
6700: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6701: 'Y', SA.Original_Item_Id,
6702: p_family_id)),

Line 6790: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6786: decode(AD.origination_type,
6787: 6, decode(AD.source_organization_id,
6788: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6789: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6790: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6791: 1, p_family_id,
6792: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6793: 'Y', AD.Original_Item_Id,
6794: p_family_id)),

Line 6799: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6795: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6796: p_level_id, NULL),
6797: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6798: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6799: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6800: 1, p_family_id,
6801: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6802: 'Y', AD.Original_Item_Id,
6803: p_family_id)),

Line 6808: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6804: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6805: p_level_id, NULL),
6806: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6807: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6808: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6809: 1, p_family_id,
6810: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6811: 'Y', AD.Original_Item_Id,
6812: p_family_id)),

Line 6819: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6815: NULL),
6816: 30, decode(AD.source_organization_id,
6817: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6818: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6819: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6820: 1, p_family_id,
6821: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6822: 'Y', AD.Original_Item_Id,
6823: p_family_id)),

Line 6828: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6824: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6825: p_level_id, NULL),
6826: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6827: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6828: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6829: 1, p_family_id,
6830: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6831: 'Y', AD.Original_Item_Id,
6832: p_family_id)),

Line 6837: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6833: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6834: p_level_id, NULL),
6835: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6836: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6837: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6838: 1, p_family_id,
6839: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6840: 'Y', AD.Original_Item_Id,
6841: p_family_id)),

Line 6847: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6843: p_level_id, NULL),
6844: NULL),
6845: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6846: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6847: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6848: 1, p_family_id,
6849: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6850: 'Y', AD.Original_Item_Id,
6851: p_family_id)),

Line 6863: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6859: AD.USING_ASSEMBLY_ITEM_ID,
6860: DECODE(AD.SOURCE_ORGANIZATION_ID,
6861: -23453, null,
6862: AD.SOURCE_ORGANIZATION_ID),
6863: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6864: 1, p_family_id,
6865: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6866: 'Y', AD.Original_Item_Id,
6867: p_family_id)),

Line 6877: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6873: decode(AD.origination_type,
6874: 6, decode(AD.source_organization_id,
6875: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6876: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6877: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6878: 1, p_family_id,
6879: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6880: 'Y', AD.Original_Item_Id,
6881: p_family_id)),

Line 6886: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6882: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6883: p_level_id, NULL),
6884: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6885: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6886: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6887: 1, p_family_id,
6888: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6889: 'Y', AD.Original_Item_Id,
6890: p_family_id)),

Line 6895: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6891: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6892: p_level_id, NULL),
6893: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6894: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6895: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6896: 1, p_family_id,
6897: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6898: 'Y', AD.Original_Item_Id,
6899: p_family_id)),

Line 6906: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6902: TEMP.LEVEL_3_DEMAND_CLASS),
6903: 30, decode(AD.source_organization_id,
6904: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6905: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6906: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6907: 1, p_family_id,
6908: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6909: 'Y', AD.Original_Item_Id,
6910: p_family_id)),

Line 6915: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6911: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6912: p_level_id, NULL),
6913: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6914: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6915: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6916: 1, p_family_id,
6917: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6918: 'Y', AD.Original_Item_Id,
6919: p_family_id)),

Line 6924: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6920: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6921: p_level_id, NULL),
6922: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6923: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6924: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6925: 1, p_family_id,
6926: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6927: 'Y', AD.Original_Item_Id,
6928: p_family_id)),

Line 6934: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6930: p_level_id, NULL),
6931: TEMP.LEVEL_3_DEMAND_CLASS),
6932: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6933: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6934: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6935: 1, p_family_id,
6936: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6937: 'Y', AD.Original_Item_Id,
6938: p_family_id)),

Line 6964: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6960: p_sr_member_id col26, -- request_item_id
6961: Decode(AD.inventory_item_id, p_family_id,
6962: Decode(AD.original_item_id, p_member_id,
6963: AD.Pf_Display_Flag,
6964: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6965: 1, AD.Pf_Display_Flag,
6966: 1)),
6967: AD.Pf_Display_Flag) col27,
6968: -1 * NVL(AD.DEMAND_QUANTITY,

Line 6976: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6972: decode(AD.origination_type,
6973: 6, decode(AD.source_organization_id,
6974: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6975: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6976: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6977: 1, p_family_id,
6978: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6979: 'Y', AD.Original_Item_Id,
6980: p_family_id)),

Line 6985: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6981: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6982: p_level_id, NULL),
6983: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6984: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6985: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6986: 1, p_family_id,
6987: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6988: 'Y', AD.Original_Item_Id,
6989: p_family_id)),

Line 6994: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6990: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6991: p_level_id, NULL),
6992: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6993: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6994: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6995: 1, p_family_id,
6996: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6997: 'Y', AD.Original_Item_Id,
6998: p_family_id)),

Line 7005: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7001: NULL),
7002: 30, decode(AD.source_organization_id,
7003: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7004: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7005: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7006: 1, p_family_id,
7007: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7008: 'Y', AD.Original_Item_Id,
7009: p_family_id)),

Line 7014: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7010: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7011: p_level_id, NULL),
7012: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7013: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7014: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7015: 1, p_family_id,
7016: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7017: 'Y', AD.Original_Item_Id,
7018: p_family_id)),

Line 7023: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7019: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7020: p_level_id, NULL),
7021: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7022: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7023: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7024: 1, p_family_id,
7025: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7026: 'Y', AD.Original_Item_Id,
7027: p_family_id)),

Line 7033: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7029: p_level_id, NULL),
7030: NULL),
7031: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7032: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7033: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7034: 1, p_family_id,
7035: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7036: 'Y', AD.Original_Item_Id,
7037: p_family_id)),

Line 7049: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7045: AD.USING_ASSEMBLY_ITEM_ID,
7046: DECODE(AD.SOURCE_ORGANIZATION_ID,
7047: -23453, null,
7048: AD.SOURCE_ORGANIZATION_ID),
7049: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7050: 1, p_family_id,
7051: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7052: 'Y', AD.Original_Item_Id,
7053: p_family_id)),

Line 7063: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7059: decode(AD.origination_type,
7060: 6, decode(AD.source_organization_id,
7061: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7062: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7063: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7064: 1, p_family_id,
7065: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7066: 'Y', AD.Original_Item_Id,
7067: p_family_id)),

Line 7072: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7068: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7069: p_level_id, NULL),
7070: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7071: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7072: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7073: 1, p_family_id,
7074: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7075: 'Y', AD.Original_Item_Id,
7076: p_family_id)),

Line 7081: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7077: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7078: p_level_id, NULL),
7079: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7080: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7081: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7082: 1, p_family_id,
7083: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7084: 'Y', AD.Original_Item_Id,
7085: p_family_id)),

Line 7092: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7088: TEMP.LEVEL_3_DEMAND_CLASS),
7089: 30, decode(AD.source_organization_id,
7090: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7091: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7092: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7093: 1, p_family_id,
7094: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7095: 'Y', AD.Original_Item_Id,
7096: p_family_id)),

Line 7101: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7097: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7098: p_level_id, NULL),
7099: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7100: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7101: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7102: 1, p_family_id,
7103: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7104: 'Y', AD.Original_Item_Id,
7105: p_family_id)),

Line 7110: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7106: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7107: p_level_id, NULL),
7108: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7109: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7110: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7111: 1, p_family_id,
7112: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7113: 'Y', AD.Original_Item_Id,
7114: p_family_id)),

Line 7120: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7116: p_level_id, NULL),
7117: TEMP.LEVEL_3_DEMAND_CLASS),
7118: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7119: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7120: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7121: 1, p_family_id,
7122: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7123: 'Y', AD.Original_Item_Id,
7124: p_family_id)),

Line 7177: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7173: * DECODE(DECODE(SA.CUSTOMER_ID, NULL, NULL,
7174: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7175: SA.CUSTOMER_ID,
7176: SA.SHIP_TO_SITE_ID,
7177: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7178: 1, p_family_id,
7179: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7180: 'Y', SA.Original_Item_Id,
7181: p_family_id)),

Line 7192: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7188: 1,
7189: NULL,
7190: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7191: p_instance_id,
7192: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7193: 1, p_family_id,
7194: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7195: 'Y', SA.Original_Item_Id,
7196: p_family_id)),

Line 7204: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7200: TEMP.LEVEL_3_DEMAND_CLASS,
7201: TRUNC(SA.SUPPLY_DATE)), 1),
7202: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7203: p_instance_id,
7204: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7205: 1, p_family_id,
7206: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7207: 'Y', SA.Original_Item_Id,
7208: p_family_id)),