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_00200_AAD_S_000006_BC_PKG dependencies on AP_SYSTEM_PARAMETERS_EXTRACT_V

Line 65238: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

65234: FROM (
65235: SELECT xet.event_id event_id
65236: , 0 line_number
65237: , CASE r
65238: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

65235: SELECT xet.event_id event_id
65236: , 0 line_number
65237: , CASE r
65238: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

65236: , 0 line_number
65237: , CASE r
65238: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

65237: , CASE r
65238: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

65238: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65239: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65240: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65241: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65242: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
65243: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65244: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65245: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
65246: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

65343: ELSE null
65344: END source_meaning
65345: FROM xla_events_gt xet
65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17
65351: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

65859: --
65860: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65861: --
65862:
65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

65860: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65861: --
65862:
65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

65861: --
65862:
65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

65862:
65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

65863: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
65864: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
65865: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
65866: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
65867: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
65868: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
65869: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
65870: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
65871: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

66047: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
66048: , h2.INV_DOC_SEQUENCE_VALUE source_124
66049: FROM xla_events_gt xet
66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66054: , fnd_lookup_values fvl17
66055: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 68096: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

68092: FROM (
68093: SELECT xet.event_id event_id
68094: , 0 line_number
68095: , CASE r
68096: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

68093: SELECT xet.event_id event_id
68094: , 0 line_number
68095: , CASE r
68096: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

68094: , 0 line_number
68095: , CASE r
68096: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

68095: , CASE r
68096: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

68096: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68097: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68098: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68099: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68100: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
68101: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68102: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68103: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
68104: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

68201: ELSE null
68202: END source_meaning
68203: FROM xla_events_gt xet
68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17
68209: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

68712: --
68713: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68714: --
68715:
68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

68713: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68714: --
68715:
68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

68714: --
68715:
68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

68715:
68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

68716: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
68717: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
68718: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
68719: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
68720: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
68721: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
68722: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68723: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
68724: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

68898: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
68899: , h2.INV_DOC_SEQUENCE_VALUE source_124
68900: FROM xla_events_gt xet
68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
68905: , fnd_lookup_values fvl17
68906: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 70928: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

70924: FROM (
70925: SELECT xet.event_id event_id
70926: , 0 line_number
70927: , CASE r
70928: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

70925: SELECT xet.event_id event_id
70926: , 0 line_number
70927: , CASE r
70928: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

70926: , 0 line_number
70927: , CASE r
70928: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

70927: , CASE r
70928: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

70928: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70929: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70930: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70931: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70932: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
70933: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70934: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70935: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
70936: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

71039: ELSE null
71040: END source_meaning
71041: FROM xla_events_gt xet
71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71047: , fnd_lookup_values fvl68

Line 71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

71565: --
71566: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71567: --
71568:
71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

71566: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71567: --
71568:
71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

71567: --
71568:
71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

71568:
71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

71569: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71570: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
71571: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71572: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
71573: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
71574: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
71575: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71576: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
71577: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

71760: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
71761: , h2.INV_DOC_SEQUENCE_VALUE source_124
71762: FROM xla_events_gt xet
71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71767: , fnd_lookup_values fvl17
71768: , fnd_lookup_values fvl68

Line 75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

75769: FROM (
75770: SELECT xet.event_id event_id
75771: , 0 line_number
75772: , CASE r
75773: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
75774: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75775: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75776: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
75777: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

75831: ELSE null
75832: END source_meaning
75833: FROM xla_events_gt xet
75834: , AP_INVOICE_EXTRACT_HEADER_V h1
75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
75836: , fnd_lookup_values fvl17
75837: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75839: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

76253: --
76254: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76255: --
76256:
76257: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76258: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
76259: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76260: TYPE t_array_source_49 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76261: TYPE t_array_source_122 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 76386: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

76382: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_123
76383: , h1.INV_DOC_SEQUENCE_VALUE source_124
76384: FROM xla_events_gt xet
76385: , AP_INVOICE_EXTRACT_HEADER_V h1
76386: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
76387: , fnd_lookup_values fvl17
76388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76389: and xet.event_class_code = C_EVENT_CLASS_CODE
76390: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 77368: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

77364: FROM (
77365: SELECT xet.event_id event_id
77366: , 0 line_number
77367: , CASE r
77368: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

77365: SELECT xet.event_id event_id
77366: , 0 line_number
77367: , CASE r
77368: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

77366: , 0 line_number
77367: , CASE r
77368: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

77367: , CASE r
77368: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

77368: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77369: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77370: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77371: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77372: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
77373: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77374: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77375: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
77376: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

77473: ELSE null
77474: END source_meaning
77475: FROM xla_events_gt xet
77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17
77481: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

77989: --
77990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77991: --
77992:
77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

77990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77991: --
77992:
77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

77991: --
77992:
77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

77992:
77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

77993: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77994: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
77995: TYPE t_array_source_10 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77996: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
77997: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77998: TYPE t_array_source_24 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
77999: TYPE t_array_source_33 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
78000: TYPE t_array_source_39 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
78001: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

78177: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
78178: , h2.INV_DOC_SEQUENCE_VALUE source_124
78179: FROM xla_events_gt xet
78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78184: , fnd_lookup_values fvl17
78185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date