[Home] [Help]
60: UNION ALL
61: SELECT
62: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
63: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
64: FROM MSC_SUPPLIES S
65: WHERE S.PLAN_ID = p_plan_id
66: AND S.SR_INSTANCE_ID = p_instance_id
67: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
68: AND S.ORGANIZATION_ID = p_org_id
77: TRUNC(NVL(S.NEW_SHIP_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
78: -- Bug 4042808 Outbound Shipments are demands. Firm Supply Date
79: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
80: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
81: FROM MSC_SUPPLIES S
82: WHERE S.PLAN_ID = p_plan_id
83: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
84: AND S.SOURCE_ORGANIZATION_ID = p_org_id
85: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
292: l_null_char, --bug3814584
293: l_null_char, --bug3814584
294: l_null_date --bug3814584
295: FROM
296: MSC_SUPPLIES S
297: WHERE S.PLAN_ID = p_plan_id
298: AND S.SR_INSTANCE_ID = p_instance_id
299: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
300: AND S.ORGANIZATION_ID = p_org_id
347: l_null_char, --bug3814584
348: l_null_char, --bug3814584
349: l_null_date --bug3814584
350: FROM
351: MSC_SUPPLIES S
352: WHERE S.PLAN_ID = p_plan_id
353: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
354: AND S.SOURCE_ORGANIZATION_ID = p_org_id
355: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
441: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
442: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
443: FROM MSC_SYSTEM_ITEMS I,
444: MSC_PLAN_ORGANIZATIONS PO,
445: MSC_SUPPLIES S
446: WHERE PO.plan_id = p_plan_id
447: AND I.PLAN_ID = PO.PLAN_ID
448: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
449: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
468: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
469: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
470: FROM MSC_SYSTEM_ITEMS I,
471: MSC_PLAN_ORGANIZATIONS PO,
472: MSC_SUPPLIES S
473: WHERE PO.plan_id = p_plan_id
474: AND I.PLAN_ID = PO.PLAN_ID
475: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
476: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
571: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
572: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
573: FROM MSC_SYSTEM_ITEMS I,
574: MSC_PLAN_ORGANIZATIONS PO,
575: MSC_SUPPLIES S
576: WHERE PO.plan_id = p_plan_id
577: AND I.PLAN_ID = PO.PLAN_ID
578: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
579: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
595: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
596: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
597: FROM MSC_SYSTEM_ITEMS I,
598: MSC_PLAN_ORGANIZATIONS PO,
599: MSC_SUPPLIES S
600: WHERE PO.plan_id = p_plan_id
601: AND I.PLAN_ID = PO.PLAN_ID
602: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
603: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
764: UNION ALL
765:
766: SELECT TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
767: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
768: FROM MSC_SUPPLIES S,
769: MSC_PLANS P -- For summary enhancement
770: WHERE S.PLAN_ID = p_plan_id
771: AND S.SR_INSTANCE_ID = p_instance_id
772: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
783: SELECT TRUNC(NVL(S.NEW_SHIP_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
784: -- Bug 4042808 Outbound Shipments are demands. Firm Supply Date
785: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
786: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
787: FROM MSC_SUPPLIES S,
788: MSC_PLANS P -- For summary enhancement
789: WHERE S.PLAN_ID = p_plan_id
790: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
791: AND S.SOURCE_ORGANIZATION_ID = p_org_id