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_TRADING_PARTNERS

Line 2567: MSC_TRADING_PARTNERS MTP,--bug3263368

2563: FROM MSC_CALENDAR_DATES C,
2564: MSC_DEMANDS D,
2565: MSC_ATP_RULES R,
2566: MSC_SYSTEM_ITEMS I,
2567: MSC_TRADING_PARTNERS MTP,--bug3263368
2568: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2569: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2570: AND I.ORGANIZATION_ID = p_org_id
2571: AND I.SR_INSTANCE_ID = p_instance_id

Line 2651: MSC_TRADING_PARTNERS MTP,--bug3263368

2647: MSC_SALES_ORDERS D,
2648: MSC_ATP_RULES R,
2649: MSC_SYSTEM_ITEMS I,
2650: MSC_CALENDAR_DATES C,
2651: MSC_TRADING_PARTNERS MTP,--bug3263368
2652: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2653: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2654: AND I.ORGANIZATION_ID = p_org_id
2655: AND I.SR_INSTANCE_ID = p_instance_id

Line 2965: MSC_TRADING_PARTNERS MTP,--bug3263368

2961: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2962: D.REQUEST_SHIP_DATE) --bug3263368
2963: FROM MSC_SYSTEM_ITEMS I,
2964: MSC_DEMANDS D,
2965: MSC_TRADING_PARTNERS MTP,--bug3263368
2966: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2967: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2968: AND I.ORGANIZATION_ID = p_org_id
2969: AND I.SR_INSTANCE_ID = p_instance_id

Line 3173: MSC_TRADING_PARTNERS MTP,--bug3263368

3169: D.REQUEST_SHIP_DATE) --bug3263368
3170: FROM MSC_SYSTEM_ITEMS I,
3171: MSC_DEMANDS D,
3172: MSC_CALENDAR_DATES C,
3173: MSC_TRADING_PARTNERS MTP,--bug3263368
3174: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3175: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
3176: AND I.ORGANIZATION_ID = p_org_id
3177: AND I.SR_INSTANCE_ID = p_instance_id

Line 9573: msc_trading_partners tp

9569: mbt.atp_flag
9570: FROM msc_bom_temp mbt,
9571: msc_calendar_dates c2,
9572: msc_calendar_dates c1,
9573: msc_trading_partners tp
9574: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
9575: --AND mbt.assembly_identifier = MSC_ATP_PVT.G_ASSEMBLY_LINE_ID
9576: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
9577: AND mbt.assembly_item_id = l_inventory_item_id

Line 11429: FROM msc_trading_partners tp,

11425: --=======================================================================================================
11426: IF l_calendar_code = '@@@' THEN
11427: SELECT tp.calendar_code
11428: INTO l_calendar_code
11429: FROM msc_trading_partners tp,
11430: msc_plans mp
11431: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
11432: AND tp.sr_instance_id = mp.sr_instance_id
11433: AND tp.partner_type = 3

Line 12614: msc_trading_partners tp,

12610: s.weight_capacity weight,
12611: s.volume_capacity volume
12612: FROM msc_calendar_dates c,
12613: msc_interorg_ship_methods s,
12614: msc_trading_partners tp,
12615: msc_plans p
12616: WHERE s.plan_id = p_plan_id
12617: AND s.from_organization_id = p_from_organization_id
12618: AND s.to_organization_id = p_to_organization_id

Line 13012: msc_trading_partners tp,

13008: null col29 -- end_pegging_id
13009: FROM
13010: msc_calendar_dates c,
13011: msc_interorg_ship_methods s,
13012: msc_trading_partners tp,
13013: msc_plans p
13014: WHERE
13015: s.plan_id = p_plan_id
13016: AND s.from_organization_id = p_from_organization_id

Line 13172: msc_trading_partners tp,

13168: null col29 -- end_pegging_id
13169: FROM
13170: msc_calendar_dates c,
13171: msc_interorg_ship_methods s,
13172: msc_trading_partners tp,
13173: msc_plans p
13174: WHERE
13175: s.plan_id = p_plan_id
13176: AND s.from_organization_id = p_from_organization_id