APPS.MSC_ATP_PF dependencies on MSC_TRADING_PARTNER_SITES

Line 2727: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

2723: MSC_ATP_RULES R,
2724: MSC_SYSTEM_ITEMS I,
2725: MSC_SYSTEM_ITEMS I0,
2726: MSC_TRADING_PARTNERS MTP,--bug3263368
2727: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2728: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2729: AND I0.ORGANIZATION_ID = p_org_id
2730: AND I0.SR_INSTANCE_ID = p_instance_id
2731: AND I0.PLAN_ID = p_plan_id

Line 2818: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

2814: MSC_SYSTEM_ITEMS I,
2815: MSC_SYSTEM_ITEMS I0,
2816: MSC_CALENDAR_DATES C,
2817: MSC_TRADING_PARTNERS MTP,--bug3263368
2818: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2819: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2820: AND I0.ORGANIZATION_ID = p_org_id
2821: AND I0.SR_INSTANCE_ID = p_instance_id
2822: AND I0.PLAN_ID = p_plan_id

Line 3181: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

3177: FROM MSC_SYSTEM_ITEMS I,
3178: MSC_SYSTEM_ITEMS I2, --bug3579625
3179: MSC_ALLOC_DEMANDS AD,
3180: MSC_TRADING_PARTNERS MTP,--bug3263368
3181: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3182: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
3183: AND I.ORGANIZATION_ID = p_org_id
3184: AND I.SR_INSTANCE_ID = p_instance_id
3185: AND I.PLAN_ID = p_plan_id

Line 5130: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368

5126: AD.REQUEST_DATE, --bug3263368
5127: I.Item_Name -- bug3579625
5128: FROM MSC_ALLOC_DEMANDS AD,
5129: MSC_TRADING_PARTNERS MTP,--bug3263368
5130: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
5131: MSC_SYSTEM_ITEMS I --bug3579625
5132: WHERE AD.PLAN_ID = p_plan_id
5133: AND AD.SR_INSTANCE_ID = p_instance_id
5134: AND AD.INVENTORY_ITEM_ID in (p_member_id,p_family_id)

Line 5638: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368

5634: AD.REQUEST_DATE, --bug3263368
5635: I.Item_Name --bug3579625
5636: FROM MSC_ALLOC_DEMANDS AD,
5637: MSC_TRADING_PARTNERS MTP,--bug3263368
5638: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
5639: MSC_SYSTEM_ITEMS I --bug3579625
5640: WHERE AD.PLAN_ID = p_plan_id
5641: AND AD.SR_INSTANCE_ID = p_instance_id
5642: AND AD.INVENTORY_ITEM_ID in (p_member_id, p_family_id)

Line 5710: MSC_TRADING_PARTNER_SITES MTPS --bug3684383

5706:
5707: FROM MSC_ALLOC_SUPPLIES SA,
5708: MSC_SYSTEM_ITEMS I, --bug3579625
5709: MSC_TRADING_PARTNERS MTP,--bug3684383
5710: MSC_TRADING_PARTNER_SITES MTPS --bug3684383
5711:
5712: WHERE SA.PLAN_ID = p_plan_id
5713: AND SA.SR_INSTANCE_ID = p_instance_id
5714: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)

Line 6071: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368

6067: FROM
6068: MSC_ALLOC_DEMANDS AD,
6069: MSC_ALLOC_TEMP TEMP,
6070: MSC_TRADING_PARTNERS MTP,--bug3263368
6071: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
6072: MSC_SYSTEM_ITEMS msi --bug3671294
6073: WHERE
6074: AD.PLAN_ID = p_plan_id
6075: AND AD.SR_INSTANCE_ID = p_instance_id

Line 6136: MSC_TRADING_PARTNER_SITES MTPS, --bug3684383

6132: FROM
6133: MSC_ALLOC_SUPPLIES SA,
6134: MSC_ALLOC_TEMP TEMP,
6135: MSC_SYSTEM_ITEMS msi, --bug3671294
6136: MSC_TRADING_PARTNER_SITES MTPS, --bug3684383
6137: MSC_TRADING_PARTNERS MTP --bug3684383
6138: WHERE
6139: SA.PLAN_ID = p_plan_id
6140: AND SA.SR_INSTANCE_ID = p_instance_id

Line 6631: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368

6627: FROM
6628: MSC_ALLOC_DEMANDS AD,
6629: MSC_ALLOC_TEMP TEMP,
6630: MSC_TRADING_PARTNERS MTP,--bug3263368
6631: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
6632: MSC_SYSTEM_ITEMS msi --bug3671294
6633: WHERE
6634: AD.PLAN_ID = p_plan_id
6635: AND AD.SR_INSTANCE_ID = p_instance_id

Line 7142: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368

7138: FROM
7139: MSC_ALLOC_DEMANDS AD,
7140: MSC_ALLOC_HIERARCHY_TEMP TEMP,
7141: MSC_TRADING_PARTNERS MTP,--bug3263368
7142: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
7143: MSC_SYSTEM_ITEMS msi --bug3671294
7144: WHERE
7145: AD.PLAN_ID = p_plan_id
7146: AND AD.SR_INSTANCE_ID = p_instance_id