APPS.MSC_ATP_PF dependencies on MSC_ATP_ALLOC

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

6075: p_org_code col20, -- Organization code
6076: Decode(AD.inventory_item_id, p_family_id,
6077: Decode(AD.original_item_id, p_member_id,
6078: AD.Pf_Display_Flag,
6079: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6080: 1, AD.Pf_Display_Flag,
6081: 1)),
6082: AD.Pf_Display_Flag) col21,
6083: -1 * NVL(AD.DEMAND_QUANTITY,

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

6213: NULL, 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 6230: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

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

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

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

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

6253: NULL, 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: -23453, 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 6283: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6279: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6280: DECODE(TEMP.DEMAND_CLASS, '-1',
6281: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6282: null, null,
6283: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6284: 1, p_family_id,
6285: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6286: 'Y', AD.Original_Item_Id,
6287: p_family_id)),

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

6292: DECODE(AD.DEMAND_CLASS, null, null,
6293: DECODE(TEMP.DEMAND_CLASS, '-1',
6294: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6295: null, null,
6296: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6297: 1, p_family_id,
6298: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6299: 'Y', AD.Original_Item_Id,
6300: p_family_id)),

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

6309: AD.USING_ASSEMBLY_ITEM_ID,
6310: DECODE(AD.SOURCE_ORGANIZATION_ID,
6311: -23453, null,
6312: AD.SOURCE_ORGANIZATION_ID),
6313: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6314: 1, p_family_id,
6315: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6316: 'Y', AD.Original_Item_Id,
6317: p_family_id)),

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

6323: NULL, 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 6340: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

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

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

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

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

6363: NULL, 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: -23453, 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 6393: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6389: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6390: DECODE(TEMP.DEMAND_CLASS, '-1',
6391: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6392: null, null,
6393: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6394: 1, p_family_id,
6395: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6396: 'Y', AD.Original_Item_Id,
6397: p_family_id)),

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

6402: DECODE(AD.DEMAND_CLASS, null, null,
6403: DECODE(TEMP.DEMAND_CLASS, '-1',
6404: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6405: null, null,
6406: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6407: 1, p_family_id,
6408: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6409: 'Y', AD.Original_Item_Id,
6410: p_family_id)),

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

6429: p_sr_member_id col21, -- request_item_id
6430: Decode(AD.inventory_item_id, p_family_id,
6431: Decode(AD.original_item_id, p_member_id,
6432: AD.Pf_Display_Flag,
6433: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6434: 1, AD.Pf_Display_Flag,
6435: 1)),
6436: AD.Pf_Display_Flag) col22,
6437: -1 * NVL(AD.DEMAND_QUANTITY,

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

6441: NULL, 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 6458: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

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

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

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

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

6481: NULL, 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: -23453, 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 6511: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6507: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6508: DECODE(TEMP.DEMAND_CLASS, '-1',
6509: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6510: null, null,
6511: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6512: 1, p_family_id,
6513: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6514: 'Y', AD.Original_Item_Id,
6515: p_family_id)),

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

6520: DECODE(AD.DEMAND_CLASS, null, null,
6521: DECODE(TEMP.DEMAND_CLASS, '-1',
6522: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6523: null, null,
6524: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6525: 1, p_family_id,
6526: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6527: 'Y', AD.Original_Item_Id,
6528: p_family_id)),

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

6537: AD.USING_ASSEMBLY_ITEM_ID,
6538: DECODE(AD.SOURCE_ORGANIZATION_ID,
6539: -23453, null,
6540: AD.SOURCE_ORGANIZATION_ID),
6541: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6542: 1, p_family_id,
6543: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6544: 'Y', AD.Original_Item_Id,
6545: p_family_id)),

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

6551: NULL, 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 6568: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

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

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

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

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

6591: NULL, 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: -23453, 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 6621: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6617: AD.organization_id, DECODE(AD.DEMAND_CLASS, null, null,
6618: DECODE(TEMP.DEMAND_CLASS, '-1',
6619: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6620: null, null,
6621: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6622: 1, p_family_id,
6623: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6624: 'Y', AD.Original_Item_Id,
6625: p_family_id)),

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

6630: DECODE(AD.DEMAND_CLASS, null, null,
6631: DECODE(TEMP.DEMAND_CLASS, '-1',
6632: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6633: null, null,
6634: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6635: 1, p_family_id,
6636: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6637: 'Y', AD.Original_Item_Id,
6638: p_family_id)),

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

6691: DECODE(TEMP.DEMAND_CLASS,'-1',
6692: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6693: null,
6694: null,
6695: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6696: 1, p_family_id,
6697: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6698: 'Y', SA.Original_Item_Id,
6699: p_family_id)),

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

6707: 1,
6708: NULL,
6709: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6710: p_instance_id,
6711: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6712: 1, p_family_id,
6713: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6714: 'Y', SA.Original_Item_Id,
6715: p_family_id)),

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

6720: TRUNC(SA.SUPPLY_DATE)),
6721: 1),
6722: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
6723: p_instance_id,
6724: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6725: 1, p_family_id,
6726: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6727: 'Y', SA.Original_Item_Id,
6728: p_family_id)),

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

6812: decode(AD.origination_type,
6813: 6, decode(AD.source_organization_id,
6814: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6815: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6816: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6817: 1, p_family_id,
6818: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6819: 'Y', AD.Original_Item_Id,
6820: p_family_id)),

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

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

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

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

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

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

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

6850: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6851: p_level_id, NULL),
6852: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6853: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6854: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6855: 1, p_family_id,
6856: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6857: 'Y', AD.Original_Item_Id,
6858: p_family_id)),

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

6859: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6860: p_level_id, NULL),
6861: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6862: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_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 6873: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

6869: p_level_id, NULL),
6870: NULL),
6871: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6872: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6873: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6874: 1, p_family_id,
6875: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6876: 'Y', AD.Original_Item_Id,
6877: p_family_id)),

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

6885: AD.USING_ASSEMBLY_ITEM_ID,
6886: DECODE(AD.SOURCE_ORGANIZATION_ID,
6887: -23453, null,
6888: AD.SOURCE_ORGANIZATION_ID),
6889: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6890: 1, p_family_id,
6891: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6892: 'Y', AD.Original_Item_Id,
6893: p_family_id)),

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

6899: decode(AD.origination_type,
6900: 6, decode(AD.source_organization_id,
6901: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6902: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6903: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6904: 1, p_family_id,
6905: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6906: 'Y', AD.Original_Item_Id,
6907: p_family_id)),

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

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

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

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

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

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

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

6937: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6938: p_level_id, NULL),
6939: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6940: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6941: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6942: 1, p_family_id,
6943: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6944: 'Y', AD.Original_Item_Id,
6945: p_family_id)),

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

6946: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
6947: p_level_id, NULL),
6948: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6949: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6950: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6951: 1, p_family_id,
6952: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6953: 'Y', AD.Original_Item_Id,
6954: p_family_id)),

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

6956: p_level_id, NULL),
6957: TEMP.LEVEL_3_DEMAND_CLASS),
6958: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
6959: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
6960: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6961: 1, p_family_id,
6962: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
6963: 'Y', AD.Original_Item_Id,
6964: p_family_id)),

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

6986: p_sr_member_id col26, -- request_item_id
6987: Decode(AD.inventory_item_id, p_family_id,
6988: Decode(AD.original_item_id, p_member_id,
6989: AD.Pf_Display_Flag,
6990: Decode(sign(trunc(AD.Original_Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
6991: 1, AD.Pf_Display_Flag,
6992: 1)),
6993: AD.Pf_Display_Flag) col27,
6994: -1 * NVL(AD.DEMAND_QUANTITY,

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

6998: decode(AD.origination_type,
6999: 6, decode(AD.source_organization_id,
7000: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7001: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7002: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7003: 1, p_family_id,
7004: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7005: 'Y', AD.Original_Item_Id,
7006: p_family_id)),

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

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

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

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

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

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

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

7036: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7037: p_level_id, NULL),
7038: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7039: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7040: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7041: 1, p_family_id,
7042: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7043: 'Y', AD.Original_Item_Id,
7044: p_family_id)),

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

7045: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7046: p_level_id, NULL),
7047: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7048: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_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 7059: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),

7055: p_level_id, NULL),
7056: NULL),
7057: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7058: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7059: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7060: 1, p_family_id,
7061: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7062: 'Y', AD.Original_Item_Id,
7063: p_family_id)),

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

7071: AD.USING_ASSEMBLY_ITEM_ID,
7072: DECODE(AD.SOURCE_ORGANIZATION_ID,
7073: -23453, null,
7074: AD.SOURCE_ORGANIZATION_ID),
7075: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7076: 1, p_family_id,
7077: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7078: 'Y', AD.Original_Item_Id,
7079: p_family_id)),

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

7085: decode(AD.origination_type,
7086: 6, decode(AD.source_organization_id,
7087: NULL, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7088: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7089: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7090: 1, p_family_id,
7091: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7092: 'Y', AD.Original_Item_Id,
7093: p_family_id)),

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

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

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

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

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

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

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

7123: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7124: p_level_id, NULL),
7125: -23453, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7126: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7127: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7128: 1, p_family_id,
7129: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7130: 'Y', AD.Original_Item_Id,
7131: p_family_id)),

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

7132: p_org_id, p_instance_id, TRUNC(AD.ORIGINAL_DEMAND_DATE),
7133: p_level_id, NULL),
7134: AD.organization_id, MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7135: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7136: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7137: 1, p_family_id,
7138: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7139: 'Y', AD.Original_Item_Id,
7140: p_family_id)),

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

7142: p_level_id, NULL),
7143: TEMP.LEVEL_3_DEMAND_CLASS),
7144: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7145: AD.CUSTOMER_ID, AD.SHIP_TO_SITE_ID,
7146: Decode(sign(trunc(AD.Demand_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7147: 1, p_family_id,
7148: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7149: 'Y', AD.Original_Item_Id,
7150: p_family_id)),

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

7199: * DECODE(DECODE(SA.CUSTOMER_ID, NULL, NULL,
7200: MSC_AATP_FUNC.Get_Hierarchy_Demand_Class(
7201: SA.CUSTOMER_ID,
7202: SA.SHIP_TO_SITE_ID,
7203: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7204: 1, p_family_id,
7205: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7206: 'Y', SA.Original_Item_Id,
7207: p_family_id)),

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

7214: 1,
7215: NULL,
7216: NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7217: p_instance_id,
7218: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7219: 1, p_family_id,
7220: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7221: 'Y', SA.Original_Item_Id,
7222: p_family_id)),

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

7226: TEMP.LEVEL_3_DEMAND_CLASS,
7227: TRUNC(SA.SUPPLY_DATE)), 1),
7228: DECODE(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
7229: p_instance_id,
7230: Decode(sign(trunc(SA.Supply_Date) - MSC_ATP_ALLOC.G_Atf_Date),
7231: 1, p_family_id,
7232: Decode(MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF,
7233: 'Y', SA.Original_Item_Id,
7234: p_family_id)),