[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
291: l_null_char, --bug3814584
292: l_null_char, --bug3814584
293: l_null_date --bug3814584
294: FROM
295: MSC_SUPPLIES S
296: WHERE S.PLAN_ID = p_plan_id
297: AND S.SR_INSTANCE_ID = p_instance_id
298: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
299: AND S.ORGANIZATION_ID = p_org_id
346: l_null_char, --bug3814584
347: l_null_char, --bug3814584
348: l_null_date --bug3814584
349: FROM
350: MSC_SUPPLIES S
351: WHERE S.PLAN_ID = p_plan_id
352: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
353: AND S.SOURCE_ORGANIZATION_ID = p_org_id
354: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
440: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
441: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
442: FROM MSC_SYSTEM_ITEMS I,
443: MSC_PLAN_ORGANIZATIONS PO,
444: MSC_SUPPLIES S
445: WHERE PO.plan_id = p_plan_id
446: AND I.PLAN_ID = PO.PLAN_ID
447: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
448: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
467: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
468: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
469: FROM MSC_SYSTEM_ITEMS I,
470: MSC_PLAN_ORGANIZATIONS PO,
471: MSC_SUPPLIES S
472: WHERE PO.plan_id = p_plan_id
473: AND I.PLAN_ID = PO.PLAN_ID
474: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
475: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
570: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
571: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
572: FROM MSC_SYSTEM_ITEMS I,
573: MSC_PLAN_ORGANIZATIONS PO,
574: MSC_SUPPLIES S
575: WHERE PO.plan_id = p_plan_id
576: AND I.PLAN_ID = PO.PLAN_ID
577: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
578: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
594: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
595: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
596: FROM MSC_SYSTEM_ITEMS I,
597: MSC_PLAN_ORGANIZATIONS PO,
598: MSC_SUPPLIES S
599: WHERE PO.plan_id = p_plan_id
600: AND I.PLAN_ID = PO.PLAN_ID
601: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
602: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID
763: UNION ALL
764:
765: SELECT TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
766: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
767: FROM MSC_SUPPLIES S,
768: MSC_PLANS P -- For summary enhancement
769: WHERE S.PLAN_ID = p_plan_id
770: AND S.SR_INSTANCE_ID = p_instance_id
771: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
782: SELECT TRUNC(NVL(S.NEW_SHIP_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
783: -- Bug 4042808 Outbound Shipments are demands. Firm Supply Date
784: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
785: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
786: FROM MSC_SUPPLIES S,
787: MSC_PLANS P -- For summary enhancement
788: WHERE S.PLAN_ID = p_plan_id
789: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
790: AND S.SOURCE_ORGANIZATION_ID = p_org_id