eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_REQ dependencies on MSC_ATP_FUNC

Line 671: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,

667: l_null_num col14,
668: l_null_char col15,
669: p_uom_code col16,
670: 1 col17, -- demand
671: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,
672: l_null_char col19,
673: -- L.MEANING col19 ,
674: REQ.SR_INSTANCE_ID col20,
675: l_null_num col21,

Line 690: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,

686: DECODE(REQ.record_source, 2, TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)),
687: TRUNC(REQ.START_DATE)) col25,
688: -- End Bug 3348095
689: l_null_num col26,
690: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,
691: l_null_num col28,
692: l_null_num col29,
693: l_sysdate,
694: FND_GLOBAL.User_ID,

Line 879: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,

875: l_null_num col14,
876: l_null_char col15,
877: p_uom_code col16,
878: 1 col17, -- demand
879: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,
880: l_null_char col19,
881: -- L.MEANING col19 ,
882: REQ.SR_INSTANCE_ID col20,
883: l_null_num col21,

Line 895: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,

891: REQ.DAILY_RESOURCE_HOURS))) col24,
892: -- End Bug 3348095
893: C.CALENDAR_DATE col25,
894: l_null_num col26,
895: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,
896: l_null_num col28,
897: l_null_num col29,
898: l_sysdate,
899: FND_GLOBAL.User_ID,

Line 1089: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,

1085: l_null_num col14,
1086: l_null_char col15,
1087: p_uom_code col16,
1088: 1 col17, -- demand
1089: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,
1090: l_null_char col19,
1091: -- L.MEANING col19 ,
1092: REQ.SR_INSTANCE_ID col20,
1093: l_null_num col21,

Line 1107: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,

1103: DECODE(REQ.record_source, 2, TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)),
1104: TRUNC(REQ.START_DATE)) col25,
1105: -- End Bug 3348095
1106: l_null_num col26,
1107: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,
1108: l_null_num col28,
1109: l_null_num col29,
1110: l_sysdate,
1111: FND_GLOBAL.User_ID,

Line 1311: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,

1307: l_null_num col14,
1308: l_null_char col15,
1309: p_uom_code col16,
1310: 1 col17, -- demand
1311: MSC_ATP_FUNC.Get_Order_Type(REQ.SUPPLY_ID, p_plan_id) col18,
1312: l_null_char col19,
1313: -- L.MEANING col19 ,
1314: REQ.SR_INSTANCE_ID col20,
1315: l_null_num col21,

Line 1330: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,

1326: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME)
1327: * NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY) col24,
1328: C.CALENDAR_DATE col25,
1329: l_null_num col26,
1330: MSC_ATP_FUNC.Get_Order_Number(REQ.SUPPLY_ID, p_plan_id) col27,
1331: l_null_num col28,
1332: l_null_num col29,
1333: l_sysdate,
1334: FND_GLOBAL.User_ID,

Line 2218: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))

2214: DECODE(R.demand_class_atp_flag,1,
2215: nvl(p_demand_class,
2216: nvl(p_default_dmd_class,'@@@')),'@@@')
2217: )))
2218: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))
2219: AND C.CALENDAR_CODE = p_cal_code
2220: AND C.EXCEPTION_SET_ID = p_cal_exc_set_id
2221: AND C.SR_INSTANCE_ID = I.SR_INSTANCE_ID
2222: -- Bug 2132288, 2442009

Line 2735: 5, MSC_ATP_FUNC.Get_Designator(S.SCHEDULE_DESIGNATOR_ID),

2731: 2, S.ORDER_NUMBER,
2732: 3, S.ORDER_NUMBER,
2733: 7, S.ORDER_NUMBER,
2734: 8, S.ORDER_NUMBER,
2735: 5, MSC_ATP_FUNC.Get_Designator(S.SCHEDULE_DESIGNATOR_ID),
2736: 11, S.ORDER_NUMBER,
2737: 12, S.ORDER_NUMBER,
2738: 14, S.ORDER_NUMBER,
2739: 15, S.ORDER_NUMBER,

Line 2815: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1

2811: DECODE(R.demand_class_atp_flag,1,
2812: nvl(p_demand_class,
2813: nvl(p_default_dmd_class,'@@@')),'@@@')
2814: )))
2815: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1
2816: AND C.CALENDAR_CODE = p_cal_code
2817: AND C.EXCEPTION_SET_ID = p_cal_exc_set_id
2818: AND C.SR_INSTANCE_ID = p_instance_id
2819: -- Bug 2132288, 2442009

Line 4086: /*l_sysdate := MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,

4082: to_char(p_parent_pegging_id) || ':' || to_char(p_plan_id) || ':'
4083: || to_char(p_instance_id) || ':' || p_inventory_item_id || ':' || p_atp_record.bill_seq_id); --4741012
4084: END IF;
4085: --bug3583705
4086: /*l_sysdate := MSC_ATP_FUNC.prev_work_day(p_atp_record.organization_id,
4087: p_atp_record.instance_id,
4088: sysdate);*/
4089: -- Note that p_quantity is the amount of the component B that is not yet
4090: -- fulfilled; B is the primary and B` the substitute component

Line 4795: /*l_infinite_time_fence_date := MSC_ATP_FUNC.get_infinite_time_fence_date(p_mat_atp_info_rec.instance_id,

4791: END IF;
4792: /* time_phased_atp changes end*/
4793:
4794: -- get the infinite time fence date if it exists
4795: /*l_infinite_time_fence_date := MSC_ATP_FUNC.get_infinite_time_fence_date(p_mat_atp_info_rec.instance_id,
4796: p_mat_atp_info_rec.inventory_item_id,p_mat_atp_info_rec.organization_id, p_mat_atp_info_rec.plan_id); */
4797: --diag_atp
4798: MSC_ATP_PROC.get_infinite_time_fence_date(p_mat_atp_info_rec.instance_id,
4799: p_mat_atp_info_rec.inventory_item_id,

Line 5396: /*l_infinite_time_fence_date := MSC_ATP_FUNC.get_infinite_time_fence_date(p_instance_id,

5392: END IF;
5393: /* time_phased_atp changes end*/
5394:
5395: --diag_atp
5396: /*l_infinite_time_fence_date := MSC_ATP_FUNC.get_infinite_time_fence_date(p_instance_id,
5397: p_inventory_item_id,p_organization_id,p_plan_id);
5398: */
5399: l_infinite_time_fence_date := p_get_mat_in_rec.infinite_time_fence_date;
5400: /* --bug 2287148

Line 5401: l_sysdate_seq_num := MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(p_organization_id,

5397: p_inventory_item_id,p_organization_id,p_plan_id);
5398: */
5399: l_infinite_time_fence_date := p_get_mat_in_rec.infinite_time_fence_date;
5400: /* --bug 2287148
5401: l_sysdate_seq_num := MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(p_organization_id,
5402: p_instance_id,
5403: sysdate);
5404: */
5405: -- for performance reason, we need to get the following info and

Line 7446: -- MSC_ATP_FUNC.get_inv_item_id(p_instance_id, p_inventory_item_id, p_organization_id)

7442: AND B.ORGANIZATION_ID = p_organization_id
7443: AND B.ASSEMBLY_ITEM_ID = l_inv_item_id
7444:
7445: -- Chnaged on 01/09/2001 by ngoel for performance improvement
7446: -- MSC_ATP_FUNC.get_inv_item_id(p_instance_id, p_inventory_item_id, p_organization_id)
7447: AND C1.CALENDAR_DATE = p_requested_date
7448: AND C1.SR_INSTANCE_ID = B.SR_INSTANCE_ID
7449: AND C1.CALENDAR_CODE = l_calendar_code
7450: AND C1.EXCEPTION_SET_ID = l_calendar_exception_set_id

Line 11629: NVL(MSC_ATP_FUNC.get_tolerance_percentage(

11625: l_atp_qty_tab
11626: FROM (
11627: SELECT c.calendar_date l_date, s.capacity*(1+
11628: DECODE(l_tolerence_defined, 0, 0,
11629: NVL(MSC_ATP_FUNC.get_tolerance_percentage(
11630: p_sup_atp_info_rec.instance_id,
11631: p_sup_atp_info_rec.plan_id,
11632: l_inv_item_id,
11633: p_sup_atp_info_rec.organization_id,

Line 11715: NVL(MSC_ATP_FUNC.get_tolerance_percentage(

11711: l_atp_qty_tab
11712: FROM (
11713: SELECT c.calendar_date l_date, s.capacity*(1+
11714: DECODE(l_tolerence_defined, 0, 0,
11715: NVL(MSC_ATP_FUNC.get_tolerance_percentage(
11716: p_sup_atp_info_rec.instance_id,
11717: p_sup_atp_info_rec.plan_id,
11718: p_sup_atp_info_rec.inventory_item_id,
11719: p_sup_atp_info_rec.organization_id,

Line 11855: NVL(MSC_ATP_FUNC.get_tolerance_percentage(

11851: l_null_num col21,
11852: l_null_num col22,
11853: l_null_num col23,
11854: s.capacity*(1+ DECODE(l_tolerence_defined, 0, 0,
11855: NVL(MSC_ATP_FUNC.get_tolerance_percentage(
11856: p_sup_atp_info_rec.instance_id,
11857: p_sup_atp_info_rec.plan_id,
11858: l_inv_item_id,
11859: p_sup_atp_info_rec.organization_id,

Line 12025: NVL(MSC_ATP_FUNC.get_tolerance_percentage(

12021: l_null_num col21,
12022: l_null_num col22,
12023: l_null_num col23,
12024: s.capacity*(1+ DECODE(l_tolerence_defined, 0, 0,
12025: NVL(MSC_ATP_FUNC.get_tolerance_percentage(
12026: p_sup_atp_info_rec.instance_id,
12027: p_sup_atp_info_rec.plan_id,
12028: p_sup_atp_info_rec.inventory_item_id,
12029: p_sup_atp_info_rec.organization_id,