[Home] [Help]
62: TO_DATE(PeriodEnd, 'YYYY-MM-DD')-1/86400,
63: case WHEN MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory = 'Demand'
64: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
65: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
66: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=msc_demands.sr_instance_id
67: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
68: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
69: AND msc_demands.origination_type=81
70: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id <> -1
95: FROM msc_demands, MSC_INT_ASCP_EXCEPTION_DETAILS
96: where MSC_INT_ASCP_EXCEPTION_DETAILS.ALERTCATEGORY = 'Demand'
97: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
98: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
99: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=msc_demands.sr_instance_id
100: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
101: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
102: AND msc_demands.origination_type=81
103: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id <> -1;
907: THEN -1
908: ELSE
909: InstanceID
910: END,
911: MSC_DEMANDS_S.NEXTVAL,
912: 81,
913: Demand,
914: Satisfied,
915: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,
963: FromOrgID,
964: ItemID,
965: PlanIdVar,
966: InstanceID,
967: MSC_DEMANDS_S.NEXTVAL, --DEMAND_ID,
968: 1, --ORIGINATION_TYPE,
969: Quantity, --BUGBUG: how to show Infinity ? --USING_REQUIREMENT_QUANTITY
970: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, --DMD_SATISFIED_DATE
971: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, --USING_ASSEMBLY_DEMAND_DATE
1008: FromOrgID,
1009: ItemID,
1010: PlanIdVar,
1011: FromInstanceID,
1012: MSC_DEMANDS_S.NEXTVAL,
1013: 82, Quantity,
1014: Quantity,
1015: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,
1016: NULL,