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.XLA_00707_AAD_S_000005_PKG dependencies on CST_XLA_WIP_HEADERS_V

Line 143162: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

143158: FROM (
143159: SELECT xet.event_id event_id
143160: , 0 line_number
143161: , CASE r
143162: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

143159: SELECT xet.event_id event_id
143160: , 0 line_number
143161: , CASE r
143162: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
143167: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

143160: , 0 line_number
143161: , CASE r
143162: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
143167: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
143168:

Line 143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

143161: , CASE r
143162: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
143167: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
143168:
143169: ELSE null

Line 143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

143162: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
143167: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
143168:
143169: ELSE null
143170: END object_name

Line 143167: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

143163: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
143164: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
143165: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
143166: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
143167: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
143168:
143169: ELSE null
143170: END object_name
143171: , CASE r

Line 143219: , CST_XLA_WIP_HEADERS_V h1

143215:
143216: ELSE null
143217: END source_meaning
143218: FROM xla_events_gt xet
143219: , CST_XLA_WIP_HEADERS_V h1
143220: , fnd_lookup_values fvl12
143221: , fnd_lookup_values fvl38
143222: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
143223: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

143481: --
143482: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
143483: --
143484:
143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

143482: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
143483: --
143484:
143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

143483: --
143484:
143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:

Line 143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

143484:
143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
143487: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143494: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 143551: , CST_XLA_WIP_HEADERS_V h1

143547: , h1.CURRENCY_CONVERSION_TYPE source_21
143548: , h1.TRANSFER_TO_GL_INDICATOR source_38
143549: , fvl38.meaning source_38_meaning
143550: FROM xla_events_gt xet
143551: , CST_XLA_WIP_HEADERS_V h1
143552: , fnd_lookup_values fvl12
143553: , fnd_lookup_values fvl38
143554: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143555: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169734: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

169730: FROM (
169731: SELECT xet.event_id event_id
169732: , 0 line_number
169733: , CASE r
169734: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
169735: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
169736: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
169737: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
169738: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 169735: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

169731: SELECT xet.event_id event_id
169732: , 0 line_number
169733: , CASE r
169734: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
169735: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
169736: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
169737: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
169738: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
169739:

Line 169736: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

169732: , 0 line_number
169733: , CASE r
169734: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
169735: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
169736: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
169737: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
169738: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
169739:
169740: ELSE null

Line 169737: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

169733: , CASE r
169734: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
169735: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
169736: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
169737: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
169738: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
169739:
169740: ELSE null
169741: END object_name

Line 169738: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

169734: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
169735: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
169736: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
169737: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
169738: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
169739:
169740: ELSE null
169741: END object_name
169742: , CASE r

Line 169786: , CST_XLA_WIP_HEADERS_V h1

169782:
169783: ELSE null
169784: END source_meaning
169785: FROM xla_events_gt xet
169786: , CST_XLA_WIP_HEADERS_V h1
169787: , fnd_lookup_values fvl12
169788: , fnd_lookup_values fvl38
169789: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

170048: --
170049: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
170050: --
170051:
170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

170049: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
170050: --
170051:
170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:

Line 170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

170050: --
170051:
170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

170051:
170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170060: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 170115: , CST_XLA_WIP_HEADERS_V h1

170111: , h1.CURRENCY_CONVERSION_RATE source_20
170112: , h1.TRANSFER_TO_GL_INDICATOR source_38
170113: , fvl38.meaning source_38_meaning
170114: FROM xla_events_gt xet
170115: , CST_XLA_WIP_HEADERS_V h1
170116: , fnd_lookup_values fvl12
170117: , fnd_lookup_values fvl38
170118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170119: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 202992: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

202988: FROM (
202989: SELECT xet.event_id event_id
202990: , 0 line_number
202991: , CASE r
202992: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

202989: SELECT xet.event_id event_id
202990: , 0 line_number
202991: , CASE r
202992: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
202997: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

202990: , 0 line_number
202991: , CASE r
202992: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
202997: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
202998:

Line 202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

202991: , CASE r
202992: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
202997: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
202998:
202999: ELSE null

Line 202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

202992: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
202997: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
202998:
202999: ELSE null
203000: END object_name

Line 202997: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

202993: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
202994: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
202995: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
202996: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
202997: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
202998:
202999: ELSE null
203000: END object_name
203001: , CASE r

Line 203049: , CST_XLA_WIP_HEADERS_V h1

203045:
203046: ELSE null
203047: END source_meaning
203048: FROM xla_events_gt xet
203049: , CST_XLA_WIP_HEADERS_V h1
203050: , fnd_lookup_values fvl12
203051: , fnd_lookup_values fvl38
203052: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
203053: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

203311: --
203312: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
203313: --
203314:
203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

203312: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
203313: --
203314:
203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

203313: --
203314:
203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:

Line 203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

203314:
203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
203317: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
203324: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 203381: , CST_XLA_WIP_HEADERS_V h1

203377: , h1.CURRENCY_CONVERSION_TYPE source_21
203378: , h1.TRANSFER_TO_GL_INDICATOR source_38
203379: , fvl38.meaning source_38_meaning
203380: FROM xla_events_gt xet
203381: , CST_XLA_WIP_HEADERS_V h1
203382: , fnd_lookup_values fvl12
203383: , fnd_lookup_values fvl38
203384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
203385: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 204203: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

204199: FROM (
204200: SELECT xet.event_id event_id
204201: , 0 line_number
204202: , CASE r
204203: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

204200: SELECT xet.event_id event_id
204201: , 0 line_number
204202: , CASE r
204203: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
204208: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

204201: , 0 line_number
204202: , CASE r
204203: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
204208: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
204209:

Line 204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

204202: , CASE r
204203: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
204208: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
204209:
204210: ELSE null

Line 204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

204203: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
204208: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
204209:
204210: ELSE null
204211: END object_name

Line 204208: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

204204: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
204205: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
204206: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
204207: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
204208: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
204209:
204210: ELSE null
204211: END object_name
204212: , CASE r

Line 204260: , CST_XLA_WIP_HEADERS_V h1

204256:
204257: ELSE null
204258: END source_meaning
204259: FROM xla_events_gt xet
204260: , CST_XLA_WIP_HEADERS_V h1
204261: , fnd_lookup_values fvl12
204262: , fnd_lookup_values fvl38
204263: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
204264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

204522: --
204523: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
204524: --
204525:
204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

204523: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
204524: --
204525:
204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

204524: --
204525:
204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:

Line 204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

204525:
204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204528: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204535: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 204592: , CST_XLA_WIP_HEADERS_V h1

204588: , h1.CURRENCY_CONVERSION_TYPE source_21
204589: , h1.TRANSFER_TO_GL_INDICATOR source_38
204590: , fvl38.meaning source_38_meaning
204591: FROM xla_events_gt xet
204592: , CST_XLA_WIP_HEADERS_V h1
204593: , fnd_lookup_values fvl12
204594: , fnd_lookup_values fvl38
204595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
204596: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 205414: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

205410: FROM (
205411: SELECT xet.event_id event_id
205412: , 0 line_number
205413: , CASE r
205414: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

205411: SELECT xet.event_id event_id
205412: , 0 line_number
205413: , CASE r
205414: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
205419: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

205412: , 0 line_number
205413: , CASE r
205414: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
205419: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
205420:

Line 205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

205413: , CASE r
205414: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
205419: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
205420:
205421: ELSE null

Line 205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

205414: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
205419: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
205420:
205421: ELSE null
205422: END object_name

Line 205419: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

205415: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
205416: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
205417: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
205418: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
205419: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
205420:
205421: ELSE null
205422: END object_name
205423: , CASE r

Line 205471: , CST_XLA_WIP_HEADERS_V h1

205467:
205468: ELSE null
205469: END source_meaning
205470: FROM xla_events_gt xet
205471: , CST_XLA_WIP_HEADERS_V h1
205472: , fnd_lookup_values fvl12
205473: , fnd_lookup_values fvl38
205474: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
205475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

205733: --
205734: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
205735: --
205736:
205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

205734: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
205735: --
205736:
205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

205735: --
205736:
205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:

Line 205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

205736:
205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
205739: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
205746: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 205803: , CST_XLA_WIP_HEADERS_V h1

205799: , h1.CURRENCY_CONVERSION_TYPE source_21
205800: , h1.TRANSFER_TO_GL_INDICATOR source_38
205801: , fvl38.meaning source_38_meaning
205802: FROM xla_events_gt xet
205803: , CST_XLA_WIP_HEADERS_V h1
205804: , fnd_lookup_values fvl12
205805: , fnd_lookup_values fvl38
205806: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205807: and xet.event_class_code = C_EVENT_CLASS_CODE