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 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 11903: FND_GLOBAL.User_ID,

11899: l_null_char col27,
11900: l_null_num col28,
11901: l_null_num col29,
11902: l_sysdate,
11903: FND_GLOBAL.User_ID,
11904: l_sysdate,
11905: FND_GLOBAL.User_ID,
11906: FND_GLOBAL.User_ID
11907: FROM msc_calendar_dates c,

Line 11905: FND_GLOBAL.User_ID,

11901: l_null_num col29,
11902: l_sysdate,
11903: FND_GLOBAL.User_ID,
11904: l_sysdate,
11905: FND_GLOBAL.User_ID,
11906: FND_GLOBAL.User_ID
11907: FROM msc_calendar_dates c,
11908: msc_supplier_capacities s
11909: WHERE s.inventory_item_id = l_inv_item_id

Line 11906: FND_GLOBAL.User_ID

11902: l_sysdate,
11903: FND_GLOBAL.User_ID,
11904: l_sysdate,
11905: FND_GLOBAL.User_ID,
11906: FND_GLOBAL.User_ID
11907: FROM msc_calendar_dates c,
11908: msc_supplier_capacities s
11909: WHERE s.inventory_item_id = l_inv_item_id
11910: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 11963: FND_GLOBAL.User_ID,

11959: DECODE(p.ORDER_TYPE, 5, to_char(p.TRANSACTION_ID), p.order_number) col27,
11960: l_null_num col28,
11961: l_null_num col29,
11962: l_sysdate,
11963: FND_GLOBAL.User_ID,
11964: l_sysdate,
11965: FND_GLOBAL.User_ID,
11966: FND_GLOBAL.User_ID
11967: -- Supplier Capacity (SCLT) Changes Begin

Line 11965: FND_GLOBAL.User_ID,

11961: l_null_num col29,
11962: l_sysdate,
11963: FND_GLOBAL.User_ID,
11964: l_sysdate,
11965: FND_GLOBAL.User_ID,
11966: FND_GLOBAL.User_ID
11967: -- Supplier Capacity (SCLT) Changes Begin
11968: FROM msc_supplies p
11969: WHERE (p.order_type IN (5, 2, 60)

Line 11966: FND_GLOBAL.User_ID

11962: l_sysdate,
11963: FND_GLOBAL.User_ID,
11964: l_sysdate,
11965: FND_GLOBAL.User_ID,
11966: FND_GLOBAL.User_ID
11967: -- Supplier Capacity (SCLT) Changes Begin
11968: FROM msc_supplies p
11969: WHERE (p.order_type IN (5, 2, 60)
11970: --include purchase orders based on profile option

Line 12073: FND_GLOBAL.User_ID,

12069: l_null_char col27,
12070: l_null_num col28,
12071: l_null_num col29,
12072: l_sysdate,
12073: FND_GLOBAL.User_ID,
12074: l_sysdate,
12075: FND_GLOBAL.User_ID,
12076: FND_GLOBAL.User_ID
12077: FROM msc_calendar_dates c,

Line 12075: FND_GLOBAL.User_ID,

12071: l_null_num col29,
12072: l_sysdate,
12073: FND_GLOBAL.User_ID,
12074: l_sysdate,
12075: FND_GLOBAL.User_ID,
12076: FND_GLOBAL.User_ID
12077: FROM msc_calendar_dates c,
12078: msc_supplier_capacities s
12079: WHERE s.inventory_item_id = l_inv_item_id

Line 12076: FND_GLOBAL.User_ID

12072: l_sysdate,
12073: FND_GLOBAL.User_ID,
12074: l_sysdate,
12075: FND_GLOBAL.User_ID,
12076: FND_GLOBAL.User_ID
12077: FROM msc_calendar_dates c,
12078: msc_supplier_capacities s
12079: WHERE s.inventory_item_id = l_inv_item_id
12080: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 12133: FND_GLOBAL.User_ID,

12129: DECODE(p.ORDER_TYPE, 5, to_char(p.TRANSACTION_ID), p.order_number) col27,
12130: l_null_num col28,
12131: l_null_num col29,
12132: l_sysdate,
12133: FND_GLOBAL.User_ID,
12134: l_sysdate,
12135: FND_GLOBAL.User_ID,
12136: FND_GLOBAL.User_ID
12137: -- Supplier Capacity (SCLT) Changes Begin

Line 12135: FND_GLOBAL.User_ID,

12131: l_null_num col29,
12132: l_sysdate,
12133: FND_GLOBAL.User_ID,
12134: l_sysdate,
12135: FND_GLOBAL.User_ID,
12136: FND_GLOBAL.User_ID
12137: -- Supplier Capacity (SCLT) Changes Begin
12138: FROM msc_supplies p
12139: WHERE (p.order_type IN (5, 2, 60)

Line 12136: FND_GLOBAL.User_ID

12132: l_sysdate,
12133: FND_GLOBAL.User_ID,
12134: l_sysdate,
12135: FND_GLOBAL.User_ID,
12136: FND_GLOBAL.User_ID
12137: -- Supplier Capacity (SCLT) Changes Begin
12138: FROM msc_supplies p
12139: WHERE (p.order_type IN (5, 2, 60)
12140: --include purchase orders based on profile option