eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_DEMANDS

Line 64: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID

60: MSC_INT_ASCP_EXCEPTION_DETAILS.Percentage,
61: TO_DATE(PeriodStart, 'YYYY-MM-DD'),
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

Line 65: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date

61: TO_DATE(PeriodStart, 'YYYY-MM-DD'),
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

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 67: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id

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
71: then

Line 68: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id

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
71: then
72: msc_demands.demand_id

Line 69: AND msc_demands.origination_type=81

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
71: then
72: msc_demands.demand_id
73: else

Line 72: msc_demands.demand_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
71: then
72: msc_demands.demand_id
73: else
74: null
75: end,
76: CASE WHEN ( MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID is not null ) AND ( INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':') = 0 )

Line 95: FROM msc_demands, MSC_INT_ASCP_EXCEPTION_DETAILS

91: SYSDATE,
92: '-1',
93: SYSDATE,
94: '-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

Line 97: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID

93: SYSDATE,
94: '-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

Line 98: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date

94: '-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

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 100: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id

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;
104: EXCEPTION WHEN others THEN

Line 101: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id

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;
104: EXCEPTION WHEN others THEN
105: g_ErrorCode := 'ERROR_UPDATE_ALERTS_001001' || ' : ' || SQLERRM;

Line 102: AND msc_demands.origination_type=81

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;
104: EXCEPTION WHEN others THEN
105: g_ErrorCode := 'ERROR_UPDATE_ALERTS_001001' || ' : ' || SQLERRM;
106: raise;

Line 144: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID

140: MSC_INT_ASCP_EXCEPTION_DETAILS.Percentage,
141: TO_DATE(PeriodStart, 'YYYY-MM-DD'),
142: TO_DATE(PeriodEnd, 'YYYY-MM-DD')-1/86400,
143: case WHEN MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory = 'Demand'
144: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
145: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
146: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID= -1
147: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
148: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id

Line 145: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date

141: TO_DATE(PeriodStart, 'YYYY-MM-DD'),
142: TO_DATE(PeriodEnd, 'YYYY-MM-DD')-1/86400,
143: case WHEN MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory = 'Demand'
144: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
145: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
146: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID= -1
147: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
148: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
149: AND msc_demands.origination_type=81

Line 147: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id

143: case WHEN MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory = 'Demand'
144: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
145: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
146: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID= -1
147: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
148: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
149: AND msc_demands.origination_type=81
150: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id = -1
151: -- CUSTOMER_SITE_ID:

Line 148: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id

144: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
145: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
146: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID= -1
147: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
148: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
149: AND msc_demands.origination_type=81
150: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id = -1
151: -- CUSTOMER_SITE_ID:
152: AND (

Line 149: AND msc_demands.origination_type=81

145: AND TO_DATE(MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
146: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID= -1
147: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
148: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
149: AND msc_demands.origination_type=81
150: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id = -1
151: -- CUSTOMER_SITE_ID:
152: AND (
153: ( MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID is not null )

Line 155: AND (SUBSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID, INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1)+1) ) = msc_demands.CUSTOMER_SITE_ID )

151: -- CUSTOMER_SITE_ID:
152: AND (
153: ( MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID is not null )
154: AND ( INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1) <> 0 )
155: AND (SUBSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID, INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1)+1) ) = msc_demands.CUSTOMER_SITE_ID )
156: -- CUSTOMER_ID:
157: AND (
158: MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID is not null )
159: AND ( INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1) <> 0 )

Line 160: AND ( SUBSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID, 1, INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1)-1) = msc_demands.CUSTOMER_ID

156: -- CUSTOMER_ID:
157: AND (
158: MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID is not null )
159: AND ( INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1) <> 0 )
160: AND ( SUBSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID, 1, INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1)-1) = msc_demands.CUSTOMER_ID
161: )
162: then
163: msc_demands.demand_id
164: else

Line 163: msc_demands.demand_id

159: AND ( INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1) <> 0 )
160: AND ( SUBSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID, 1, INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':',1,1)-1) = msc_demands.CUSTOMER_ID
161: )
162: then
163: msc_demands.demand_id
164: else
165: null
166: end,
167: CASE WHEN ( MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID is not null ) AND ( INSTR(MSC_INT_ASCP_EXCEPTION_DETAILS.Zone_ID,':') = 0 )

Line 186: FROM msc_demands, MSC_INT_ASCP_EXCEPTION_DETAILS

182: SYSDATE,
183: '-1',
184: SYSDATE,
185: '-1'
186: FROM msc_demands, MSC_INT_ASCP_EXCEPTION_DETAILS
187: where MSC_INT_ASCP_EXCEPTION_DETAILS.ALERTCATEGORY = 'Demand'
188: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
190: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=-1

Line 188: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID

184: SYSDATE,
185: '-1'
186: FROM msc_demands, MSC_INT_ASCP_EXCEPTION_DETAILS
187: where MSC_INT_ASCP_EXCEPTION_DETAILS.ALERTCATEGORY = 'Demand'
188: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
190: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=-1
191: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
192: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id

Line 189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date

185: '-1'
186: FROM msc_demands, MSC_INT_ASCP_EXCEPTION_DETAILS
187: where MSC_INT_ASCP_EXCEPTION_DETAILS.ALERTCATEGORY = 'Demand'
188: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
190: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=-1
191: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
192: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
193: AND msc_demands.origination_type=81

Line 191: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id

187: where MSC_INT_ASCP_EXCEPTION_DETAILS.ALERTCATEGORY = 'Demand'
188: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
190: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=-1
191: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
192: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
193: AND msc_demands.origination_type=81
194: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id = -1;
195: EXCEPTION WHEN others THEN

Line 192: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id

188: AND msc_demands.plan_id=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
190: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=-1
191: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
192: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
193: AND msc_demands.origination_type=81
194: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id = -1;
195: EXCEPTION WHEN others THEN
196: g_ErrorCode := 'ERROR_UPDATE_ALERTS_001001' || ' : ' || SQLERRM;

Line 193: AND msc_demands.origination_type=81

189: AND TO_DATE( MSC_INT_ASCP_EXCEPTION_DETAILS.PERIODEND, 'YYYY-MM-DD')-1/86400 =msc_demands.dmd_satisfied_date
190: AND MSC_INT_ASCP_EXCEPTION_DETAILS.INSTANCE_ID=-1
191: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID=msc_demands.inventory_item_id
192: AND MSC_INT_ASCP_EXCEPTION_DETAILS.ORGANIZATION_ID=msc_demands.organization_id
193: AND msc_demands.origination_type=81
194: AND MSC_INT_ASCP_EXCEPTION_DETAILS.organization_id = -1;
195: EXCEPTION WHEN others THEN
196: g_ErrorCode := 'ERROR_UPDATE_ALERTS_001001' || ' : ' || SQLERRM;
197: raise;

Line 976: DELETE FROM MSC_DEMANDS WHERE PLAN_ID=PlanIdVar;

972:
973:
974: -- delete records from MSC_WS_DEMANDS table for the given PlanIdVar, if any
975: BEGIN
976: DELETE FROM MSC_DEMANDS WHERE PLAN_ID=PlanIdVar;
977: EXCEPTION WHEN others THEN
978: NULL; -- do nothing
979: END;
980: -- insert new rows

Line 986: -- populate MSC_DEMANDS from ASCP Demand (Forecast/Satisfied)

982:
983: BEGIN
984: -- CODE GOES HERE
985: --
986: -- populate MSC_DEMANDS from ASCP Demand (Forecast/Satisfied)
987: --
988: INSERT INTO MSC_DEMANDS (
989: ORGANIZATION_ID,
990: INVENTORY_ITEM_ID,

Line 988: INSERT INTO MSC_DEMANDS (

984: -- CODE GOES HERE
985: --
986: -- populate MSC_DEMANDS from ASCP Demand (Forecast/Satisfied)
987: --
988: INSERT INTO MSC_DEMANDS (
989: ORGANIZATION_ID,
990: INVENTORY_ITEM_ID,
991: PLAN_ID,
992: SR_INSTANCE_ID,

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 1052: -- populate MSC_DEMANDS from ASCP Dependent Demand

1048: g_ErrorCode := 'ERROR_UPDATE_DEMAND_FROM_ASCP_DEMAND_001001' || ' : ' || SQLERRM;
1049: raise;
1050: END;
1051: BEGIN
1052: -- populate MSC_DEMANDS from ASCP Dependent Demand
1053: --
1054: INSERT INTO MSC_DEMANDS (
1055: ORGANIZATION_ID,
1056: INVENTORY_ITEM_ID,

Line 1054: INSERT INTO MSC_DEMANDS (

1050: END;
1051: BEGIN
1052: -- populate MSC_DEMANDS from ASCP Dependent Demand
1053: --
1054: INSERT INTO MSC_DEMANDS (
1055: ORGANIZATION_ID,
1056: INVENTORY_ITEM_ID,
1057: PLAN_ID,
1058: SR_INSTANCE_ID,

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 1093: -- populate MSC_DEMANDS from ASCP Transportation (Move Order)

1089:
1090: BEGIN
1091: -- CODE GOES HERE
1092: --
1093: -- populate MSC_DEMANDS from ASCP Transportation (Move Order)
1094: --
1095: INSERT INTO MSC_DEMANDS (ORGANIZATION_ID,
1096: INVENTORY_ITEM_ID,
1097: PLAN_ID,

Line 1095: INSERT INTO MSC_DEMANDS (ORGANIZATION_ID,

1091: -- CODE GOES HERE
1092: --
1093: -- populate MSC_DEMANDS from ASCP Transportation (Move Order)
1094: --
1095: INSERT INTO MSC_DEMANDS (ORGANIZATION_ID,
1096: INVENTORY_ITEM_ID,
1097: PLAN_ID,
1098: SR_INSTANCE_ID,
1099: DEMAND_ID,

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,