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_00222_AAD_S_000017_PKG dependencies on AR_TRANSACTIONS_S_V

Line 63052: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

63048: , CASE r
63049: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
63050: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
63051: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
63052: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
63053: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'
63054: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
63055: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
63056:

Line 63110: , AR_TRANSACTIONS_S_V h7

63106: , AR_ADJUSTMENTS_H_V h1
63107: , AR_BILL_TO_CUSTOMERS_S_V h2
63108: , AR_BILL_TO_SITE_USES_S_V h3
63109: , AR_RECEIVABLES_TRX_ACT_S_V h6
63110: , AR_TRANSACTIONS_S_V h7
63111: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
63112: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63113: AND xet.event_class_code = C_EVENT_CLASS_CODE
63114: AND h1.event_id = xet.event_id

Line 63401: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

63397:
63398: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
63399: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
63400: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
63401: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
63402: TYPE t_array_source_107 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63403: TYPE t_array_source_108 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63404: TYPE t_array_source_109 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
63405:

Line 63477: , AR_TRANSACTIONS_S_V h7

63473: , AR_ADJUSTMENTS_H_V h1
63474: , AR_BILL_TO_CUSTOMERS_S_V h2
63475: , AR_BILL_TO_SITE_USES_S_V h3
63476: , AR_RECEIVABLES_TRX_ACT_S_V h6
63477: , AR_TRANSACTIONS_S_V h7
63478: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63479: and xet.event_class_code = C_EVENT_CLASS_CODE
63480: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
63481: AND h2.event_id = h1.event_id

Line 64502: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

64498: , 0 line_number
64499: , CASE r
64500: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
64501: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
64502: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
64503: WHEN 4 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
64504: WHEN 5 THEN 'AR_DRAWEE_SITE_USES_H_V'
64505:
64506: ELSE null

Line 64550: , AR_TRANSACTIONS_S_V h6

64546: FROM xla_events_gt xet
64547: , AR_DRAWEE_CUSTOMERS_H_V h3
64548: , AR_DRAWEE_SITE_USES_H_V h4
64549: , AR_SYSTEM_PARAM_H_V h5
64550: , AR_TRANSACTIONS_S_V h6
64551: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
64552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64553: AND xet.event_class_code = C_EVENT_CLASS_CODE
64554: AND h3.event_id = xet.event_id

Line 64839: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

64835: --
64836:
64837: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_41 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64842:
64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64909: , AR_TRANSACTIONS_S_V h6

64905: FROM xla_events_gt xet
64906: , AR_DRAWEE_CUSTOMERS_H_V h3
64907: , AR_DRAWEE_SITE_USES_H_V h4
64908: , AR_SYSTEM_PARAM_H_V h5
64909: , AR_TRANSACTIONS_S_V h6
64910: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64911: and xet.event_class_code = C_EVENT_CLASS_CODE
64912: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
64913: AND h4.event_id = h3.event_id

Line 65857: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

65853: FROM (
65854: SELECT xet.event_id event_id
65855: , 0 line_number
65856: , CASE r
65857: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
65858: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

65856: , CASE r
65857: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
65858: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
65862: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
65863: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
65864:

Line 65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

65857: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
65858: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
65862: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
65863: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
65864:
65865: ELSE null

Line 65862: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

65858: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
65862: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
65863: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
65864:
65865: ELSE null
65866: END object_name

Line 65863: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
65862: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
65863: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
65864:
65865: ELSE null
65866: END object_name
65867: , CASE r

Line 65916: , AR_TRANSACTIONS_S_V h5

65912: , null source_meaning
65913: FROM xla_events_gt xet
65914: , AR_BILL_TO_CUSTOMERS_S_V h1
65915: , AR_BILL_TO_SITE_USES_S_V h2
65916: , AR_TRANSACTIONS_S_V h5
65917: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
65918: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65919: AND xet.event_class_code = C_EVENT_CLASS_CODE
65920: AND h1.event_id = xet.event_id

Line 66197: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

66193: --
66194: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66195: --
66196:
66197: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66198: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66199: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

66196:
66197: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66198: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66199: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66202: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66203: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66204:

Line 66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

66197: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66198: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66199: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66202: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66203: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66204:
66205: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 66202: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

66198: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66199: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66202: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66203: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66204:
66205: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
66206: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 66203: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

66199: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66202: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66203: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66204:
66205: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
66206: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
66207: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 66272: , AR_TRANSACTIONS_S_V h5

66268: , h5.TRX_DOC_SEQUENCE_ID source_112
66269: FROM xla_events_gt xet
66270: , AR_BILL_TO_CUSTOMERS_S_V h1
66271: , AR_BILL_TO_SITE_USES_S_V h2
66272: , AR_TRANSACTIONS_S_V h5
66273: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66274: and xet.event_class_code = C_EVENT_CLASS_CODE
66275: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
66276: AND h2.event_id = h1.event_id

Line 67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

67104: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67105: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67106: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67112: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 67186: , AR_TRANSACTIONS_S_V h3

67182: END source_meaning
67183: FROM xla_events_gt xet
67184: , AR_BILL_TO_CUSTOMERS_S_V h1
67185: , AR_BILL_TO_SITE_USES_S_V h2
67186: , AR_TRANSACTIONS_S_V h3
67187: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67188: , fnd_lookup_values fvl116
67189: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
67190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

67564: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67565: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67566: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67567: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67570: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 67682: , AR_TRANSACTIONS_S_V h3

67678: , fvl116.meaning source_116_meaning
67679: FROM xla_events_gt xet
67680: , AR_BILL_TO_CUSTOMERS_S_V h1
67681: , AR_BILL_TO_SITE_USES_S_V h2
67682: , AR_TRANSACTIONS_S_V h3
67683: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67684: , fnd_lookup_values fvl116
67685: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67686: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 68917: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

68913: FROM (
68914: SELECT xet.event_id event_id
68915: , l3.line_number line_number
68916: , CASE r
68917: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68918: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 68918: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

68914: SELECT xet.event_id event_id
68915: , l3.line_number line_number
68916: , CASE r
68917: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68918: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

68915: , l3.line_number line_number
68916: , CASE r
68917: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68918: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68923: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 69039: , AR_TRANSACTIONS_S_V l10

69035: , AR_CM_LINES_L_V l4
69036: , AR_CUST_TRX_LINES_L_V l6
69037: , AR_DISTRIBUTIONS_L_V l7
69038: , AR_RECEIVABLES_TRX_ACT_S_V l8
69039: , AR_TRANSACTIONS_S_V l10
69040: , (select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
69041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69042: AND xet.event_class_code = C_EVENT_CLASS_CODE
69043: AND l3.event_id = xet.event_id

Line 69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69193:
69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69193:
69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69193:
69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69200: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69347: , AR_TRANSACTIONS_S_V l10

69343: , AR_CM_LINES_L_V l4
69344: , AR_CUST_TRX_LINES_L_V l6
69345: , AR_DISTRIBUTIONS_L_V l7
69346: , AR_RECEIVABLES_TRX_ACT_S_V l8
69347: , AR_TRANSACTIONS_S_V l10
69348: WHERE xet.event_id between x_first_event_id and x_last_event_id
69349: and xet.event_date between p_pad_start_date and p_pad_end_date
69350: and xet.event_class_code = C_EVENT_CLASS_CODE
69351: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 70504: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

70500: FROM (
70501: SELECT xet.event_id event_id
70502: , 0 line_number
70503: , CASE r
70504: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
70505: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

70503: , CASE r
70504: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
70505: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70509: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70510: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70511:

Line 70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

70504: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
70505: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70509: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70510: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70511:
70512: ELSE null

Line 70509: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

70505: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70509: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70510: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70511:
70512: ELSE null
70513: END object_name

Line 70510: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70509: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70510: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
70511:
70512: ELSE null
70513: END object_name
70514: , CASE r

Line 70563: , AR_TRANSACTIONS_S_V h5

70559: , null source_meaning
70560: FROM xla_events_gt xet
70561: , AR_BILL_TO_CUSTOMERS_S_V h1
70562: , AR_BILL_TO_SITE_USES_S_V h2
70563: , AR_TRANSACTIONS_S_V h5
70564: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
70565: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70566: AND xet.event_class_code = C_EVENT_CLASS_CODE
70567: AND h1.event_id = xet.event_id

Line 70854: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

70850: --
70851: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70852: --
70853:
70854: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

70853:
70854: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70861:

Line 70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

70854: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70861:
70862: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 70859: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

70855: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70861:
70862: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 70860: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

70856: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70861:
70862: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70864: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 70933: , AR_TRANSACTIONS_S_V h5

70929: , h5.TRX_DOC_SEQUENCE_ID source_112
70930: FROM xla_events_gt xet
70931: , AR_BILL_TO_CUSTOMERS_S_V h1
70932: , AR_BILL_TO_SITE_USES_S_V h2
70933: , AR_TRANSACTIONS_S_V h5
70934: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70935: and xet.event_class_code = C_EVENT_CLASS_CODE
70936: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
70937: AND h2.event_id = h1.event_id

Line 71964: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

71960: FROM (
71961: SELECT xet.event_id event_id
71962: , 0 line_number
71963: , CASE r
71964: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71965: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

71963: , CASE r
71964: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71965: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71969: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71970: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71971:

Line 71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

71964: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71965: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71969: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71970: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71971:
71972: ELSE null

Line 71969: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

71965: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71969: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71970: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71971:
71972: ELSE null
71973: END object_name

Line 71970: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71969: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71970: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71971:
71972: ELSE null
71973: END object_name
71974: , CASE r

Line 72023: , AR_TRANSACTIONS_S_V h5

72019: , null source_meaning
72020: FROM xla_events_gt xet
72021: , AR_BILL_TO_CUSTOMERS_S_V h1
72022: , AR_BILL_TO_SITE_USES_S_V h2
72023: , AR_TRANSACTIONS_S_V h5
72024: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72025: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72026: AND xet.event_class_code = C_EVENT_CLASS_CODE
72027: AND h1.event_id = xet.event_id

Line 72304: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

72300: --
72301: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72302: --
72303:
72304: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

72303:
72304: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72309: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72310: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72311:

Line 72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

72304: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72309: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72310: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72311:
72312: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72309: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

72305: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72309: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72310: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72311:
72312: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72313: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 72310: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

72306: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72309: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72310: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72311:
72312: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72313: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72314: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72379: , AR_TRANSACTIONS_S_V h5

72375: , h5.TRX_DOC_SEQUENCE_ID source_112
72376: FROM xla_events_gt xet
72377: , AR_BILL_TO_CUSTOMERS_S_V h1
72378: , AR_BILL_TO_SITE_USES_S_V h2
72379: , AR_TRANSACTIONS_S_V h5
72380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72381: and xet.event_class_code = C_EVENT_CLASS_CODE
72382: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
72383: AND h2.event_id = h1.event_id

Line 73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

73211: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73212: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73213: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73219: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 73293: , AR_TRANSACTIONS_S_V h3

73289: END source_meaning
73290: FROM xla_events_gt xet
73291: , AR_BILL_TO_CUSTOMERS_S_V h1
73292: , AR_BILL_TO_SITE_USES_S_V h2
73293: , AR_TRANSACTIONS_S_V h3
73294: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73295: , fnd_lookup_values fvl116
73296: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
73297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

73676: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73677: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73678: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73679: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73682: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 73796: , AR_TRANSACTIONS_S_V h3

73792: , fvl116.meaning source_116_meaning
73793: FROM xla_events_gt xet
73794: , AR_BILL_TO_CUSTOMERS_S_V h1
73795: , AR_BILL_TO_SITE_USES_S_V h2
73796: , AR_TRANSACTIONS_S_V h3
73797: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73798: , fnd_lookup_values fvl116
73799: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73800: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 74950: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

74946: FROM (
74947: SELECT xet.event_id event_id
74948: , 0 line_number
74949: , CASE r
74950: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74951: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

74949: , CASE r
74950: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74951: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74955: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74956: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74957:

Line 74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

74950: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74951: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74955: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74956: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74957:
74958: ELSE null

Line 74955: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

74951: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74955: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74956: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74957:
74958: ELSE null
74959: END object_name

Line 74956: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74955: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74956: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74957:
74958: ELSE null
74959: END object_name
74960: , CASE r

Line 75009: , AR_TRANSACTIONS_S_V h5

75005: , null source_meaning
75006: FROM xla_events_gt xet
75007: , AR_BILL_TO_CUSTOMERS_S_V h1
75008: , AR_BILL_TO_SITE_USES_S_V h2
75009: , AR_TRANSACTIONS_S_V h5
75010: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75011: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75012: AND xet.event_class_code = C_EVENT_CLASS_CODE
75013: AND h1.event_id = xet.event_id

Line 75290: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

75286: --
75287: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75288: --
75289:
75290: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75291: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75292: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

75289:
75290: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75291: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75292: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75295: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75296: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75297:

Line 75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

75290: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75291: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75292: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75295: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75296: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75297:
75298: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75295: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

75291: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75292: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75295: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75296: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75297:
75298: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75299: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 75296: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

75292: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75295: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75296: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75297:
75298: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75299: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75300: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75365: , AR_TRANSACTIONS_S_V h5

75361: , h5.TRX_DOC_SEQUENCE_ID source_112
75362: FROM xla_events_gt xet
75363: , AR_BILL_TO_CUSTOMERS_S_V h1
75364: , AR_BILL_TO_SITE_USES_S_V h2
75365: , AR_TRANSACTIONS_S_V h5
75366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75367: and xet.event_class_code = C_EVENT_CLASS_CODE
75368: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
75369: AND h2.event_id = h1.event_id

Line 76196: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

76192: FROM (
76193: SELECT xet.event_id event_id
76194: , 0 line_number
76195: , CASE r
76196: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
76197: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

76195: , CASE r
76196: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
76197: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
76201: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
76202: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
76203:

Line 76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

76196: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
76197: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
76201: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
76202: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
76203:
76204: ELSE null

Line 76201: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

76197: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
76201: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
76202: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
76203:
76204: ELSE null
76205: END object_name

Line 76202: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
76201: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
76202: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
76203:
76204: ELSE null
76205: END object_name
76206: , CASE r

Line 76255: , AR_TRANSACTIONS_S_V h5

76251: , null source_meaning
76252: FROM xla_events_gt xet
76253: , AR_BILL_TO_CUSTOMERS_S_V h1
76254: , AR_BILL_TO_SITE_USES_S_V h2
76255: , AR_TRANSACTIONS_S_V h5
76256: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
76257: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76258: AND xet.event_class_code = C_EVENT_CLASS_CODE
76259: AND h1.event_id = xet.event_id

Line 76551: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

76547: --
76548: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76549: --
76550:
76551: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76552: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76553: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

76550:
76551: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76552: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76553: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76556: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76557: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76558:

Line 76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

76551: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76552: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76553: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76556: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76557: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76558:
76559: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76556: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

76552: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76553: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76556: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76557: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76558:
76559: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76560: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 76557: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

76553: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76556: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76557: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76558:
76559: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76560: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76561: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76632: , AR_TRANSACTIONS_S_V h5

76628: , h5.TRX_DOC_SEQUENCE_ID source_112
76629: FROM xla_events_gt xet
76630: , AR_BILL_TO_CUSTOMERS_S_V h1
76631: , AR_BILL_TO_SITE_USES_S_V h2
76632: , AR_TRANSACTIONS_S_V h5
76633: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76634: and xet.event_class_code = C_EVENT_CLASS_CODE
76635: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
76636: AND h2.event_id = h1.event_id

Line 79455: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

79451: FROM (
79452: SELECT xet.event_id event_id
79453: , l4.line_number line_number
79454: , CASE r
79455: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

79452: SELECT xet.event_id event_id
79453: , l4.line_number line_number
79454: , CASE r
79455: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

79453: , l4.line_number line_number
79454: , CASE r
79455: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79461: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79474: WHEN 20 THEN 'AR_TRANSACTIONS_S_V'

79470: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
79471: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
79472: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
79473: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
79474: WHEN 20 THEN 'AR_TRANSACTIONS_S_V'
79475: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
79476: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
79477: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
79478: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79475: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'

79471: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
79472: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
79473: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
79474: WHEN 20 THEN 'AR_TRANSACTIONS_S_V'
79475: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
79476: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
79477: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
79478: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
79479: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79631: , AR_TRANSACTIONS_S_V l10

79627: , AR_CUST_TRX_LINES_L_V l2
79628: , AR_DISTRIBUTIONS_BASE_V l3
79629: , AR_DISTRIBUTIONS_L_V l4
79630: , AR_RECEIVABLES_TRX_ACT_S_V l7
79631: , AR_TRANSACTIONS_S_V l10
79632: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
79633: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79634: AND xet.event_class_code = C_EVENT_CLASS_CODE
79635: AND l3.event_id = xet.event_id

Line 79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79794:
79795: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79801: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79814: TYPE t_array_source_93 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

79810: TYPE t_array_source_44 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79811: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79812: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79813: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79814: TYPE t_array_source_93 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79815: TYPE t_array_source_94 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79816: TYPE t_array_source_95 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79817: TYPE t_array_source_96 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79818: TYPE t_array_source_97 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79815: TYPE t_array_source_94 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

79811: TYPE t_array_source_45 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79812: TYPE t_array_source_88 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79813: TYPE t_array_source_89 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79814: TYPE t_array_source_93 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79815: TYPE t_array_source_94 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79816: TYPE t_array_source_95 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79817: TYPE t_array_source_96 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79818: TYPE t_array_source_97 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79819: TYPE t_array_source_98 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80004: , AR_TRANSACTIONS_S_V l10

80000: , AR_CUST_TRX_LINES_L_V l2
80001: , AR_DISTRIBUTIONS_BASE_V l3
80002: , AR_DISTRIBUTIONS_L_V l4
80003: , AR_RECEIVABLES_TRX_ACT_S_V l7
80004: , AR_TRANSACTIONS_S_V l10
80005: WHERE xet.event_id between x_first_event_id and x_last_event_id
80006: and xet.event_date between p_pad_start_date and p_pad_end_date
80007: and xet.event_class_code = C_EVENT_CLASS_CODE
80008: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id