APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_DEMANDS_S

Line 66: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=msc_demands.sr_instance_id

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

Line 99: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=msc_demands.sr_instance_id

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;

Line 1019: MSC_DEMANDS_S.NEXTVAL,

1015: END,
1016: ItemID,
1017: PlanIdVar,
1018: InstanceID,
1019: MSC_DEMANDS_S.NEXTVAL,
1020: 81,
1021: Demand,
1022: Satisfied,
1023: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,

Line 1075: MSC_DEMANDS_S.NEXTVAL, --DEMAND_ID,

1071: FromOrgID,
1072: ItemID,
1073: PlanIdVar,
1074: InstanceID,
1075: MSC_DEMANDS_S.NEXTVAL, --DEMAND_ID,
1076: 1, --ORIGINATION_TYPE,
1077: Quantity, --BUGBUG: how to show Infinity ? --USING_REQUIREMENT_QUANTITY
1078: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, --DMD_SATISFIED_DATE
1079: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, --USING_ASSEMBLY_DEMAND_DATE

Line 1120: MSC_DEMANDS_S.NEXTVAL,

1116: FromOrgID,
1117: ItemID,
1118: PlanIdVar,
1119: FromInstanceID,
1120: MSC_DEMANDS_S.NEXTVAL,
1121: 82,
1122: Quantity,
1123: Quantity,
1124: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,