DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on MSC_ATP_REQ

Line 1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);

1669: l_sysdate := sysdate;
1670: l_user_id := FND_GLOBAL.USER_ID;
1671:
1672: ---profile option for including purchase order
1673: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);
1674:
1675: IF p_full_refresh = 1 THEN -- Full refresh - for summary enhancement
1676:
1677: -- Data for share_partition='N' has already been deleted

Line 7916: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

7912: msc_system_items I
7913: WHERE I.plan_id = p_plan_id
7914: AND I.atp_components_flag in ( 'Y', 'C')
7915: AND (p.order_type IN (5, 2)
7916: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
7917: AND p.order_type = 1 AND p.promised_date IS NULL))
7918: AND p.plan_id = I.plan_id
7919: AND p.sr_instance_id = I.sr_instance_id
7920: AND p.inventory_item_id = I.inventory_item_id

Line 8001: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

7997: msc_system_items I
7998: WHERE I.plan_id = p_plan_id
7999: AND I.atp_components_flag in ( 'Y', 'C')
8000: AND (p.order_type IN (5, 2)
8001: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
8002: AND p.order_type = 1 AND p.promised_date IS NULL))
8003: AND p.plan_id = I.plan_id
8004: AND p.sr_instance_id = I.sr_instance_id
8005: AND p.inventory_item_id = I.inventory_item_id