APPS.BIV_DBI_COLLECTION_AGE dependencies on OKI_DBI_MULTIPLEXER_B

Line 135: , oki_dbi_multiplexer_b m

131: + 86399/86400,l_collect_to_date) report_date
132: , sum( power(2,m.id) ) record_type_id
133: from
134: biv_trend_rpt t
135: , oki_dbi_multiplexer_b m
136: where t.current_ind = 1
137: and m.id <= 12
138: and t.offset > case
139: when m.id in (1,5,9) then -13

Line 183: from oki_dbi_multiplexer_b

179: when id = 11 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
180: when id = 6 then (trunc(l_collect_to_date))
181: else l_collect_to_date
182: end the_date
183: from oki_dbi_multiplexer_b
184: where id in (1,6,11)
185: ) m
186: where fii.start_date < m.the_date
187: )

Line 207: from oki_dbi_multiplexer_b

203: when id = 12 then FII_TIME_API.sd_lyswk(l_collect_to_date)
204: when id = 7 then FII_TIME_API.sd_pwk(l_collect_to_date)
205: else l_collect_to_date
206: end the_date
207: from oki_dbi_multiplexer_b
208: where id in (2,7,12)
209: ) m
210: where fii.start_date < m.the_date
211: )

Line 231: from oki_dbi_multiplexer_b

227: when id = 13 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date)
228: when id = 8 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date)
229: else l_collect_to_date
230: end the_date
231: from oki_dbi_multiplexer_b
232: where id in (3,8,13)
233: ) m
234: where fii.start_date < m.the_date
235: )

Line 255: from oki_dbi_multiplexer_b

251: when id = 14 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date)
252: when id = 9 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date)
253: else l_collect_to_date
254: end the_date
255: from oki_dbi_multiplexer_b
256: where id in (4,9,14)
257: ) m
258: where fii.start_date < m.the_date
259: )

Line 279: from oki_dbi_multiplexer_b

275: when id = 15 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
276: when id = 10 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
277: else l_collect_to_date
278: end the_date
279: from oki_dbi_multiplexer_b
280: where id in (5,10,15)
281: ) m
282: where fii.start_date < m.the_date
283: )