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.

[Home] [Help]

APPS.MSC_ATP_REQ dependencies on FND_GLOBAL

Line 694: FND_GLOBAL.User_ID,

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,
695: l_sysdate,
696: FND_GLOBAL.User_ID,
697: FND_GLOBAL.User_ID
698: FROM MSC_DEPARTMENT_RESOURCES DR,

Line 696: FND_GLOBAL.User_ID,

692: l_null_num col29,
693: l_sysdate,
694: FND_GLOBAL.User_ID,
695: l_sysdate,
696: FND_GLOBAL.User_ID,
697: FND_GLOBAL.User_ID
698: FROM MSC_DEPARTMENT_RESOURCES DR,
699: MSC_RESOURCE_REQUIREMENTS REQ,
700: -- CTO Option Dependent Resources

Line 697: FND_GLOBAL.User_ID

693: l_sysdate,
694: FND_GLOBAL.User_ID,
695: l_sysdate,
696: FND_GLOBAL.User_ID,
697: FND_GLOBAL.User_ID
698: FROM MSC_DEPARTMENT_RESOURCES DR,
699: MSC_RESOURCE_REQUIREMENTS REQ,
700: -- CTO Option Dependent Resources
701: -- Option Dependent Resources Capacity Check

Line 782: FND_GLOBAL.User_ID,

778: l_null_char col27,
779: l_null_num col28,
780: l_null_num col29,
781: l_sysdate,
782: FND_GLOBAL.User_ID,
783: l_sysdate,
784: FND_GLOBAL.User_ID,
785: FND_GLOBAL.User_ID
786: FROM MSC_NET_RESOURCE_AVAIL

Line 784: FND_GLOBAL.User_ID,

780: l_null_num col29,
781: l_sysdate,
782: FND_GLOBAL.User_ID,
783: l_sysdate,
784: FND_GLOBAL.User_ID,
785: FND_GLOBAL.User_ID
786: FROM MSC_NET_RESOURCE_AVAIL
787: WHERE PLAN_ID = p_plan_id
788: AND NVL(PARENT_ID, -2) <> -1

Line 785: FND_GLOBAL.User_ID

781: l_sysdate,
782: FND_GLOBAL.User_ID,
783: l_sysdate,
784: FND_GLOBAL.User_ID,
785: FND_GLOBAL.User_ID
786: FROM MSC_NET_RESOURCE_AVAIL
787: WHERE PLAN_ID = p_plan_id
788: AND NVL(PARENT_ID, -2) <> -1
789: AND SR_INSTANCE_ID = p_instance_id

Line 899: FND_GLOBAL.User_ID,

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,
900: l_sysdate,
901: FND_GLOBAL.User_ID,
902: FND_GLOBAL.User_ID
903: FROM MSC_DEPARTMENT_RESOURCES DR,

Line 901: FND_GLOBAL.User_ID,

897: l_null_num col29,
898: l_sysdate,
899: FND_GLOBAL.User_ID,
900: l_sysdate,
901: FND_GLOBAL.User_ID,
902: FND_GLOBAL.User_ID
903: FROM MSC_DEPARTMENT_RESOURCES DR,
904: MSC_RESOURCE_REQUIREMENTS REQ,
905: -- CTO Option Dependent Resources

Line 902: FND_GLOBAL.User_ID

898: l_sysdate,
899: FND_GLOBAL.User_ID,
900: l_sysdate,
901: FND_GLOBAL.User_ID,
902: FND_GLOBAL.User_ID
903: FROM MSC_DEPARTMENT_RESOURCES DR,
904: MSC_RESOURCE_REQUIREMENTS REQ,
905: -- CTO Option Dependent Resources
906: -- Option Dependent Resources Capacity Check

Line 990: FND_GLOBAL.User_ID,

986: l_null_char col27,
987: l_null_num col28,
988: l_null_num col29,
989: l_sysdate,
990: FND_GLOBAL.User_ID,
991: l_sysdate,
992: FND_GLOBAL.User_ID,
993: FND_GLOBAL.User_ID
994: FROM MSC_NET_RESOURCE_AVAIL

Line 992: FND_GLOBAL.User_ID,

988: l_null_num col29,
989: l_sysdate,
990: FND_GLOBAL.User_ID,
991: l_sysdate,
992: FND_GLOBAL.User_ID,
993: FND_GLOBAL.User_ID
994: FROM MSC_NET_RESOURCE_AVAIL
995: WHERE PLAN_ID = p_plan_id
996: AND NVL(PARENT_ID, -2) <> -1

Line 993: FND_GLOBAL.User_ID

989: l_sysdate,
990: FND_GLOBAL.User_ID,
991: l_sysdate,
992: FND_GLOBAL.User_ID,
993: FND_GLOBAL.User_ID
994: FROM MSC_NET_RESOURCE_AVAIL
995: WHERE PLAN_ID = p_plan_id
996: AND NVL(PARENT_ID, -2) <> -1
997: AND SR_INSTANCE_ID = p_instance_id

Line 1111: FND_GLOBAL.User_ID,

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,
1112: l_sysdate,
1113: FND_GLOBAL.User_ID,
1114: FND_GLOBAL.User_ID
1115: FROM MSC_DEPARTMENT_RESOURCES DR,

Line 1113: FND_GLOBAL.User_ID,

1109: l_null_num col29,
1110: l_sysdate,
1111: FND_GLOBAL.User_ID,
1112: l_sysdate,
1113: FND_GLOBAL.User_ID,
1114: FND_GLOBAL.User_ID
1115: FROM MSC_DEPARTMENT_RESOURCES DR,
1116: MSC_RESOURCE_REQUIREMENTS REQ,
1117: -- 2859130 MSC_CALENDAR_DATES C,

Line 1114: FND_GLOBAL.User_ID

1110: l_sysdate,
1111: FND_GLOBAL.User_ID,
1112: l_sysdate,
1113: FND_GLOBAL.User_ID,
1114: FND_GLOBAL.User_ID
1115: FROM MSC_DEPARTMENT_RESOURCES DR,
1116: MSC_RESOURCE_REQUIREMENTS REQ,
1117: -- 2859130 MSC_CALENDAR_DATES C,
1118: ---tables added for resource batching

Line 1210: FND_GLOBAL.User_ID,

1206: l_null_char col27,
1207: l_null_num col28,
1208: l_null_num col29,
1209: l_sysdate,
1210: FND_GLOBAL.User_ID,
1211: l_sysdate,
1212: FND_GLOBAL.User_ID,
1213: FND_GLOBAL.User_ID
1214: FROM MSC_NET_RESOURCE_AVAIL

Line 1212: FND_GLOBAL.User_ID,

1208: l_null_num col29,
1209: l_sysdate,
1210: FND_GLOBAL.User_ID,
1211: l_sysdate,
1212: FND_GLOBAL.User_ID,
1213: FND_GLOBAL.User_ID
1214: FROM MSC_NET_RESOURCE_AVAIL
1215: WHERE PLAN_ID = p_plan_id
1216: AND NVL(PARENT_ID, -2) <> -1

Line 1213: FND_GLOBAL.User_ID

1209: l_sysdate,
1210: FND_GLOBAL.User_ID,
1211: l_sysdate,
1212: FND_GLOBAL.User_ID,
1213: FND_GLOBAL.User_ID
1214: FROM MSC_NET_RESOURCE_AVAIL
1215: WHERE PLAN_ID = p_plan_id
1216: AND NVL(PARENT_ID, -2) <> -1
1217: AND SR_INSTANCE_ID = p_instance_id

Line 1334: FND_GLOBAL.User_ID,

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,
1335: l_sysdate,
1336: FND_GLOBAL.User_ID,
1337: FND_GLOBAL.User_ID
1338: FROM MSC_DEPARTMENT_RESOURCES DR,

Line 1336: FND_GLOBAL.User_ID,

1332: l_null_num col29,
1333: l_sysdate,
1334: FND_GLOBAL.User_ID,
1335: l_sysdate,
1336: FND_GLOBAL.User_ID,
1337: FND_GLOBAL.User_ID
1338: FROM MSC_DEPARTMENT_RESOURCES DR,
1339: MSC_RESOURCE_REQUIREMENTS REQ,
1340: MSC_CALENDAR_DATES C,

Line 1337: FND_GLOBAL.User_ID

1333: l_sysdate,
1334: FND_GLOBAL.User_ID,
1335: l_sysdate,
1336: FND_GLOBAL.User_ID,
1337: FND_GLOBAL.User_ID
1338: FROM MSC_DEPARTMENT_RESOURCES DR,
1339: MSC_RESOURCE_REQUIREMENTS REQ,
1340: MSC_CALENDAR_DATES C,
1341: ---tables added for resource batching

Line 1436: FND_GLOBAL.User_ID,

1432: l_null_char col27,
1433: l_null_num col28,
1434: l_null_num col29,
1435: l_sysdate,
1436: FND_GLOBAL.User_ID,
1437: l_sysdate,
1438: FND_GLOBAL.User_ID,
1439: FND_GLOBAL.User_ID
1440: FROM MSC_NET_RESOURCE_AVAIL

Line 1438: FND_GLOBAL.User_ID,

1434: l_null_num col29,
1435: l_sysdate,
1436: FND_GLOBAL.User_ID,
1437: l_sysdate,
1438: FND_GLOBAL.User_ID,
1439: FND_GLOBAL.User_ID
1440: FROM MSC_NET_RESOURCE_AVAIL
1441: WHERE PLAN_ID = p_plan_id
1442: AND NVL(PARENT_ID, -2) <> -1

Line 1439: FND_GLOBAL.User_ID

1435: l_sysdate,
1436: FND_GLOBAL.User_ID,
1437: l_sysdate,
1438: FND_GLOBAL.User_ID,
1439: FND_GLOBAL.User_ID
1440: FROM MSC_NET_RESOURCE_AVAIL
1441: WHERE PLAN_ID = p_plan_id
1442: AND NVL(PARENT_ID, -2) <> -1
1443: AND SR_INSTANCE_ID = p_instance_id

Line 2554: FND_GLOBAL.User_ID,

2550: -- in disposition_name column
2551: l_null_num col28,
2552: l_null_num col29,
2553: l_sysdate,
2554: FND_GLOBAL.User_ID,
2555: l_sysdate,
2556: FND_GLOBAL.User_ID,
2557: FND_GLOBAL.User_ID,
2558: MTPS.LOCATION, --bug3263368

Line 2556: FND_GLOBAL.User_ID,

2552: l_null_num col29,
2553: l_sysdate,
2554: FND_GLOBAL.User_ID,
2555: l_sysdate,
2556: FND_GLOBAL.User_ID,
2557: FND_GLOBAL.User_ID,
2558: MTPS.LOCATION, --bug3263368
2559: MTP.PARTNER_NAME, --bug3263368
2560: D.DEMAND_CLASS, --bug3263368

Line 2557: FND_GLOBAL.User_ID,

2553: l_sysdate,
2554: FND_GLOBAL.User_ID,
2555: l_sysdate,
2556: FND_GLOBAL.User_ID,
2557: FND_GLOBAL.User_ID,
2558: MTPS.LOCATION, --bug3263368
2559: MTP.PARTNER_NAME, --bug3263368
2560: D.DEMAND_CLASS, --bug3263368
2561: trunc(DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE, --4135752

Line 2637: FND_GLOBAL.User_ID,

2633: D.SALES_ORDER_NUMBER col27,
2634: l_null_num col28,
2635: l_null_num col29,
2636: l_sysdate,
2637: FND_GLOBAL.User_ID,
2638: l_sysdate,
2639: FND_GLOBAL.User_ID,
2640: FND_GLOBAL.User_ID,
2641: MTPS.LOCATION, --bug3263368

Line 2639: FND_GLOBAL.User_ID,

2635: l_null_num col29,
2636: l_sysdate,
2637: FND_GLOBAL.User_ID,
2638: l_sysdate,
2639: FND_GLOBAL.User_ID,
2640: FND_GLOBAL.User_ID,
2641: MTPS.LOCATION, --bug3263368
2642: MTP.PARTNER_NAME, --bug3263368
2643: D.DEMAND_CLASS, --bug3263368

Line 2640: FND_GLOBAL.User_ID,

2636: l_sysdate,
2637: FND_GLOBAL.User_ID,
2638: l_sysdate,
2639: FND_GLOBAL.User_ID,
2640: FND_GLOBAL.User_ID,
2641: MTPS.LOCATION, --bug3263368
2642: MTP.PARTNER_NAME, --bug3263368
2643: D.DEMAND_CLASS, --bug3263368
2644: trunc(DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE, --4135752

Line 2748: FND_GLOBAL.User_ID,

2744: l_null_char) col27, --bug3814584
2745: l_null_num col28,
2746: l_null_num col29,
2747: l_sysdate,
2748: FND_GLOBAL.User_ID,
2749: l_sysdate,
2750: FND_GLOBAL.User_ID,
2751: FND_GLOBAL.User_ID,
2752: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME

Line 2750: FND_GLOBAL.User_ID,

2746: l_null_num col29,
2747: l_sysdate,
2748: FND_GLOBAL.User_ID,
2749: l_sysdate,
2750: FND_GLOBAL.User_ID,
2751: FND_GLOBAL.User_ID,
2752: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
2753: --null, --bug3263368 ORIG_CUSTOMER_NAME
2754: --null, --bug3263368 ORIG_DEMAND_CLASS

Line 2751: FND_GLOBAL.User_ID,

2747: l_sysdate,
2748: FND_GLOBAL.User_ID,
2749: l_sysdate,
2750: FND_GLOBAL.User_ID,
2751: FND_GLOBAL.User_ID,
2752: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
2753: --null, --bug3263368 ORIG_CUSTOMER_NAME
2754: --null, --bug3263368 ORIG_DEMAND_CLASS
2755: --null --bug3263368 ORIG_REQUEST_DATE

Line 2954: FND_GLOBAL.User_ID,

2950: D.ORDER_NUMBER col27,
2951: l_null_num col28,
2952: l_null_num col29,
2953: l_sysdate,
2954: FND_GLOBAL.User_ID,
2955: l_sysdate,
2956: FND_GLOBAL.User_ID,
2957: FND_GLOBAL.User_ID,
2958: MTPS.LOCATION, --bug3263368

Line 2956: FND_GLOBAL.User_ID,

2952: l_null_num col29,
2953: l_sysdate,
2954: FND_GLOBAL.User_ID,
2955: l_sysdate,
2956: FND_GLOBAL.User_ID,
2957: FND_GLOBAL.User_ID,
2958: MTPS.LOCATION, --bug3263368
2959: MTP.PARTNER_NAME, --bug3263368
2960: D.DEMAND_CLASS, --bug3263368

Line 2957: FND_GLOBAL.User_ID,

2953: l_sysdate,
2954: FND_GLOBAL.User_ID,
2955: l_sysdate,
2956: FND_GLOBAL.User_ID,
2957: FND_GLOBAL.User_ID,
2958: MTPS.LOCATION, --bug3263368
2959: MTP.PARTNER_NAME, --bug3263368
2960: D.DEMAND_CLASS, --bug3263368
2961: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,

Line 3033: FND_GLOBAL.User_ID,

3029: DECODE(S.ORDER_TYPE, 5, to_char(S.TRANSACTION_ID), S.ORDER_NUMBER) col27,
3030: l_null_num col28,
3031: l_null_num col29,
3032: l_sysdate,
3033: FND_GLOBAL.User_ID,
3034: l_sysdate,
3035: FND_GLOBAL.User_ID,
3036: FND_GLOBAL.User_ID,
3037: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME

Line 3035: FND_GLOBAL.User_ID,

3031: l_null_num col29,
3032: l_sysdate,
3033: FND_GLOBAL.User_ID,
3034: l_sysdate,
3035: FND_GLOBAL.User_ID,
3036: FND_GLOBAL.User_ID,
3037: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
3038: --null, --bug3263368 ORIG_CUSTOMER_NAME
3039: --null, --bug3263368 ORIG_DEMAND_CLASS

Line 3036: FND_GLOBAL.User_ID,

3032: l_sysdate,
3033: FND_GLOBAL.User_ID,
3034: l_sysdate,
3035: FND_GLOBAL.User_ID,
3036: FND_GLOBAL.User_ID,
3037: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
3038: --null, --bug3263368 ORIG_CUSTOMER_NAME
3039: --null, --bug3263368 ORIG_DEMAND_CLASS
3040: --null --bug3263368 ORIG_REQUEST_DATE

Line 3161: FND_GLOBAL.User_ID,

3157: D.ORDER_NUMBER col27,
3158: l_null_num col28,
3159: l_null_num col29,
3160: l_sysdate,
3161: FND_GLOBAL.User_ID,
3162: l_sysdate,
3163: FND_GLOBAL.User_ID,
3164: FND_GLOBAL.User_ID,
3165: MTPS.LOCATION, --bug3263368

Line 3163: FND_GLOBAL.User_ID,

3159: l_null_num col29,
3160: l_sysdate,
3161: FND_GLOBAL.User_ID,
3162: l_sysdate,
3163: FND_GLOBAL.User_ID,
3164: FND_GLOBAL.User_ID,
3165: MTPS.LOCATION, --bug3263368
3166: MTP.PARTNER_NAME, --bug3263368
3167: D.DEMAND_CLASS, --bug3263368

Line 3164: FND_GLOBAL.User_ID,

3160: l_sysdate,
3161: FND_GLOBAL.User_ID,
3162: l_sysdate,
3163: FND_GLOBAL.User_ID,
3164: FND_GLOBAL.User_ID,
3165: MTPS.LOCATION, --bug3263368
3166: MTP.PARTNER_NAME, --bug3263368
3167: D.DEMAND_CLASS, --bug3263368
3168: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,

Line 3253: FND_GLOBAL.User_ID,

3249: DECODE(S.ORDER_TYPE, 5, to_char(S.TRANSACTION_ID), S.ORDER_NUMBER) col27,
3250: l_null_num col28,
3251: l_null_num col29,
3252: l_sysdate,
3253: FND_GLOBAL.User_ID,
3254: l_sysdate,
3255: FND_GLOBAL.User_ID,
3256: FND_GLOBAL.User_ID,
3257: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME

Line 3255: FND_GLOBAL.User_ID,

3251: l_null_num col29,
3252: l_sysdate,
3253: FND_GLOBAL.User_ID,
3254: l_sysdate,
3255: FND_GLOBAL.User_ID,
3256: FND_GLOBAL.User_ID,
3257: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
3258: --null, --bug3263368 ORIG_CUSTOMER_NAME
3259: --null, --bug3263368 ORIG_DEMAND_CLASS

Line 3256: FND_GLOBAL.User_ID,

3252: l_sysdate,
3253: FND_GLOBAL.User_ID,
3254: l_sysdate,
3255: FND_GLOBAL.User_ID,
3256: FND_GLOBAL.User_ID,
3257: --null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
3258: --null, --bug3263368 ORIG_CUSTOMER_NAME
3259: --null, --bug3263368 ORIG_DEMAND_CLASS
3260: --null --bug3263368 ORIG_REQUEST_DATE

Line 11870: FND_GLOBAL.User_ID,

11866: l_null_char col27,
11867: l_null_num col28,
11868: l_null_num col29,
11869: l_sysdate,
11870: FND_GLOBAL.User_ID,
11871: l_sysdate,
11872: FND_GLOBAL.User_ID,
11873: FND_GLOBAL.User_ID
11874: FROM msc_calendar_dates c,

Line 11872: FND_GLOBAL.User_ID,

11868: l_null_num col29,
11869: l_sysdate,
11870: FND_GLOBAL.User_ID,
11871: l_sysdate,
11872: FND_GLOBAL.User_ID,
11873: FND_GLOBAL.User_ID
11874: FROM msc_calendar_dates c,
11875: msc_supplier_capacities s
11876: WHERE s.inventory_item_id = l_inv_item_id

Line 11873: FND_GLOBAL.User_ID

11869: l_sysdate,
11870: FND_GLOBAL.User_ID,
11871: l_sysdate,
11872: FND_GLOBAL.User_ID,
11873: FND_GLOBAL.User_ID
11874: FROM msc_calendar_dates c,
11875: msc_supplier_capacities s
11876: WHERE s.inventory_item_id = l_inv_item_id
11877: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 11930: FND_GLOBAL.User_ID,

11926: DECODE(p.ORDER_TYPE, 5, to_char(p.TRANSACTION_ID), p.order_number) col27,
11927: l_null_num col28,
11928: l_null_num col29,
11929: l_sysdate,
11930: FND_GLOBAL.User_ID,
11931: l_sysdate,
11932: FND_GLOBAL.User_ID,
11933: FND_GLOBAL.User_ID
11934: -- Supplier Capacity (SCLT) Changes Begin

Line 11932: FND_GLOBAL.User_ID,

11928: l_null_num col29,
11929: l_sysdate,
11930: FND_GLOBAL.User_ID,
11931: l_sysdate,
11932: FND_GLOBAL.User_ID,
11933: FND_GLOBAL.User_ID
11934: -- Supplier Capacity (SCLT) Changes Begin
11935: FROM msc_supplies p
11936: WHERE (p.order_type IN (5, 2, 60)

Line 11933: FND_GLOBAL.User_ID

11929: l_sysdate,
11930: FND_GLOBAL.User_ID,
11931: l_sysdate,
11932: FND_GLOBAL.User_ID,
11933: FND_GLOBAL.User_ID
11934: -- Supplier Capacity (SCLT) Changes Begin
11935: FROM msc_supplies p
11936: WHERE (p.order_type IN (5, 2, 60)
11937: --include purchase orders based on profile option

Line 12040: FND_GLOBAL.User_ID,

12036: l_null_char col27,
12037: l_null_num col28,
12038: l_null_num col29,
12039: l_sysdate,
12040: FND_GLOBAL.User_ID,
12041: l_sysdate,
12042: FND_GLOBAL.User_ID,
12043: FND_GLOBAL.User_ID
12044: FROM msc_calendar_dates c,

Line 12042: FND_GLOBAL.User_ID,

12038: l_null_num col29,
12039: l_sysdate,
12040: FND_GLOBAL.User_ID,
12041: l_sysdate,
12042: FND_GLOBAL.User_ID,
12043: FND_GLOBAL.User_ID
12044: FROM msc_calendar_dates c,
12045: msc_supplier_capacities s
12046: WHERE s.inventory_item_id = l_inv_item_id

Line 12043: FND_GLOBAL.User_ID

12039: l_sysdate,
12040: FND_GLOBAL.User_ID,
12041: l_sysdate,
12042: FND_GLOBAL.User_ID,
12043: FND_GLOBAL.User_ID
12044: FROM msc_calendar_dates c,
12045: msc_supplier_capacities s
12046: WHERE s.inventory_item_id = l_inv_item_id
12047: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 12100: FND_GLOBAL.User_ID,

12096: DECODE(p.ORDER_TYPE, 5, to_char(p.TRANSACTION_ID), p.order_number) col27,
12097: l_null_num col28,
12098: l_null_num col29,
12099: l_sysdate,
12100: FND_GLOBAL.User_ID,
12101: l_sysdate,
12102: FND_GLOBAL.User_ID,
12103: FND_GLOBAL.User_ID
12104: -- Supplier Capacity (SCLT) Changes Begin

Line 12102: FND_GLOBAL.User_ID,

12098: l_null_num col29,
12099: l_sysdate,
12100: FND_GLOBAL.User_ID,
12101: l_sysdate,
12102: FND_GLOBAL.User_ID,
12103: FND_GLOBAL.User_ID
12104: -- Supplier Capacity (SCLT) Changes Begin
12105: FROM msc_supplies p
12106: WHERE (p.order_type IN (5, 2, 60)

Line 12103: FND_GLOBAL.User_ID

12099: l_sysdate,
12100: FND_GLOBAL.User_ID,
12101: l_sysdate,
12102: FND_GLOBAL.User_ID,
12103: FND_GLOBAL.User_ID
12104: -- Supplier Capacity (SCLT) Changes Begin
12105: FROM msc_supplies p
12106: WHERE (p.order_type IN (5, 2, 60)
12107: --include purchase orders based on profile option