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

Line 66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

66547: WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'
66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
66552: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
66553: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
66554:
66555: ELSE null

Line 66612: , AR_TRANSACTIONS_S_V h7

66608: , AR_ADJUSTMENTS_H_V h1
66609: , AR_BILL_TO_CUSTOMERS_S_V h2
66610: , AR_BILL_TO_SITE_USES_S_V h3
66611: , AR_RECEIVABLES_TRX_ACT_S_V h6
66612: , AR_TRANSACTIONS_S_V h7
66613: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
66614: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66615: AND xet.event_class_code = C_EVENT_CLASS_CODE
66616: AND h1.event_id = xet.event_id

Line 66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

66901: TYPE t_array_source_2 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66902: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66904: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 66982: , AR_TRANSACTIONS_S_V h7

66978: , AR_ADJUSTMENTS_H_V h1
66979: , AR_BILL_TO_CUSTOMERS_S_V h2
66980: , AR_BILL_TO_SITE_USES_S_V h3
66981: , AR_RECEIVABLES_TRX_ACT_S_V h6
66982: , AR_TRANSACTIONS_S_V h7
66983: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66984: and xet.event_class_code = C_EVENT_CLASS_CODE
66985: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
66986: AND h2.event_id = h1.event_id

Line 68017: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

68013: FROM (
68014: SELECT xet.event_id event_id
68015: , 0 line_number
68016: , CASE r
68017: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68018: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 68018: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

68014: SELECT xet.event_id event_id
68015: , 0 line_number
68016: , CASE r
68017: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68018: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68022: WHEN 6 THEN 'AR_DRAWEE_CUSTOMERS_H_V'

Line 68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

68017: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68018: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68022: WHEN 6 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
68023: WHEN 7 THEN 'AR_DRAWEE_SITE_USES_H_V'
68024:
68025: ELSE null

Line 68077: , AR_TRANSACTIONS_S_V h6

68073: FROM xla_events_gt xet
68074: , AR_DRAWEE_CUSTOMERS_H_V h3
68075: , AR_DRAWEE_SITE_USES_H_V h4
68076: , AR_SYSTEM_PARAM_H_V h5
68077: , AR_TRANSACTIONS_S_V h6
68078: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68079: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68080: AND xet.event_class_code = C_EVENT_CLASS_CODE
68081: AND h3.event_id = xet.event_id

Line 68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

68360: --
68361: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68362: --
68363:
68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

68361: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68362: --
68363:
68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68369: TYPE t_array_source_53 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68369: TYPE t_array_source_53 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68370: TYPE t_array_source_54 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68371:
68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68442: , AR_TRANSACTIONS_S_V h6

68438: FROM xla_events_gt xet
68439: , AR_DRAWEE_CUSTOMERS_H_V h3
68440: , AR_DRAWEE_SITE_USES_H_V h4
68441: , AR_SYSTEM_PARAM_H_V h5
68442: , AR_TRANSACTIONS_S_V h6
68443: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68444: and xet.event_class_code = C_EVENT_CLASS_CODE
68445: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
68446: AND h4.event_id = h3.event_id

Line 69404: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

69400: FROM (
69401: SELECT xet.event_id event_id
69402: , 0 line_number
69403: , CASE r
69404: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69405: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

Line 69405: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

69401: SELECT xet.event_id event_id
69402: , 0 line_number
69403: , CASE r
69404: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69405: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

69402: , 0 line_number
69403: , CASE r
69404: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69405: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

69403: , CASE r
69404: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69405: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69411: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69411: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
69412: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
69413:
69414: ELSE null

Line 69411: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69411: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
69412: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
69413:
69414: ELSE null
69415: END object_name

Line 69412: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69411: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
69412: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
69413:
69414: ELSE null
69415: END object_name
69416: , CASE r

Line 69473: , AR_TRANSACTIONS_S_V h5

69469: , null source_meaning
69470: FROM xla_events_gt xet
69471: , AR_BILL_TO_CUSTOMERS_S_V h1
69472: , AR_BILL_TO_SITE_USES_S_V h2
69473: , AR_TRANSACTIONS_S_V h5
69474: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69476: AND xet.event_class_code = C_EVENT_CLASS_CODE
69477: AND h1.event_id = xet.event_id

Line 69754: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

69750: --
69751: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69752: --
69753:
69754: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69755: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69756: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69755: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

69751: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69752: --
69753:
69754: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69755: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69756: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69759: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69756: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

69752: --
69753:
69754: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69755: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69756: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69759: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

69753:
69754: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69755: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69756: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69759: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

69756: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69759: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

69757: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69759: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69759: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69835: , AR_TRANSACTIONS_S_V h5

69831: , h5.TRX_DOC_SEQUENCE_ID source_120
69832: FROM xla_events_gt xet
69833: , AR_BILL_TO_CUSTOMERS_S_V h1
69834: , AR_BILL_TO_SITE_USES_S_V h2
69835: , AR_TRANSACTIONS_S_V h5
69836: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69837: and xet.event_class_code = C_EVENT_CLASS_CODE
69838: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
69839: AND h2.event_id = h1.event_id

Line 70693: WHEN 12 THEN 'AR_TRANSACTIONS_S_V'

70689: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'
70690: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
70691: WHEN 10 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70692: WHEN 11 THEN 'AR_BILL_TO_SITE_USES_S_V'
70693: WHEN 12 THEN 'AR_TRANSACTIONS_S_V'
70694: WHEN 13 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70695: WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70696: WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70697: WHEN 16 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 70796: , AR_TRANSACTIONS_S_V h4

70792: FROM xla_events_gt xet
70793: , AR_BILL_TO_CUSTOMERS_S_V h1
70794: , AR_BILL_TO_SITE_USES_S_V h2
70795: , AR_REMIT_BANK_ACCT_H_V h3
70796: , AR_TRANSACTIONS_S_V h4
70797: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
70798: , fnd_lookup_values fvl124
70799: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
70800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71185: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

71181: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
71182: TYPE t_array_source_19 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NUM%TYPE INDEX BY BINARY_INTEGER;
71183: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71184: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71185: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71186: TYPE t_array_source_93 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71187: TYPE t_array_source_121 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
71188: TYPE t_array_source_122 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
71189: TYPE t_array_source_123 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 71312: , AR_TRANSACTIONS_S_V h4

71308: FROM xla_events_gt xet
71309: , AR_BILL_TO_CUSTOMERS_S_V h1
71310: , AR_BILL_TO_SITE_USES_S_V h2
71311: , AR_REMIT_BANK_ACCT_H_V h3
71312: , AR_TRANSACTIONS_S_V h4
71313: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
71314: , fnd_lookup_values fvl124
71315: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71316: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 72592: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

72588: FROM (
72589: SELECT xet.event_id event_id
72590: , l3.line_number line_number
72591: , CASE r
72592: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72593: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 72593: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

72589: SELECT xet.event_id event_id
72590: , l3.line_number line_number
72591: , CASE r
72592: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72593: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

72590: , l3.line_number line_number
72591: , CASE r
72592: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72593: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
72598: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 72708: , AR_TRANSACTIONS_S_V l9

72704: , AR_CM_LINES_BASE_V l3
72705: , AR_CM_LINES_L_V l4
72706: , AR_DISTRIBUTIONS_L_V l6
72707: , AR_RECEIVABLES_TRX_ACT_S_V l7
72708: , AR_TRANSACTIONS_S_V l9
72709: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72710: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72711: AND xet.event_class_code = C_EVENT_CLASS_CODE
72712: AND l3.event_id = xet.event_id

Line 72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72863:
72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72863:
72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72863:
72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72870: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73019: , AR_TRANSACTIONS_S_V l9

73015: , AR_CM_LINES_BASE_V l3
73016: , AR_CM_LINES_L_V l4
73017: , AR_DISTRIBUTIONS_L_V l6
73018: , AR_RECEIVABLES_TRX_ACT_S_V l7
73019: , AR_TRANSACTIONS_S_V l9
73020: WHERE xet.event_id between x_first_event_id and x_last_event_id
73021: and xet.event_date between p_pad_start_date and p_pad_end_date
73022: and xet.event_class_code = C_EVENT_CLASS_CODE
73023: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74221: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

74217: FROM (
74218: SELECT xet.event_id event_id
74219: , 0 line_number
74220: , CASE r
74221: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74222: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

Line 74222: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

74218: SELECT xet.event_id event_id
74219: , 0 line_number
74220: , CASE r
74221: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74222: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

74219: , 0 line_number
74220: , CASE r
74221: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74222: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

74220: , CASE r
74221: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74222: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74228: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74228: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
74229: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
74230:
74231: ELSE null

Line 74228: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74228: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
74229: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
74230:
74231: ELSE null
74232: END object_name

Line 74229: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74228: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
74229: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
74230:
74231: ELSE null
74232: END object_name
74233: , CASE r

Line 74290: , AR_TRANSACTIONS_S_V h5

74286: , null source_meaning
74287: FROM xla_events_gt xet
74288: , AR_BILL_TO_CUSTOMERS_S_V h1
74289: , AR_BILL_TO_SITE_USES_S_V h2
74290: , AR_TRANSACTIONS_S_V h5
74291: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74292: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74293: AND xet.event_class_code = C_EVENT_CLASS_CODE
74294: AND h1.event_id = xet.event_id

Line 74576: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

74572: --
74573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74574: --
74575:
74576: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
74577: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74578: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74577: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

74573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74574: --
74575:
74576: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
74577: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74578: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74581: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74578: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

74574: --
74575:
74576: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
74577: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74578: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74581: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

74575:
74576: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
74577: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74578: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74581: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

74578: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74581: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

74579: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74581: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74581: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74659: , AR_TRANSACTIONS_S_V h5

74655: , h5.TRX_DOC_SEQUENCE_ID source_120
74656: FROM xla_events_gt xet
74657: , AR_BILL_TO_CUSTOMERS_S_V h1
74658: , AR_BILL_TO_SITE_USES_S_V h2
74659: , AR_TRANSACTIONS_S_V h5
74660: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74661: and xet.event_class_code = C_EVENT_CLASS_CODE
74662: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
74663: AND h2.event_id = h1.event_id

Line 75734: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

75730: FROM (
75731: SELECT xet.event_id event_id
75732: , 0 line_number
75733: , CASE r
75734: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75735: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

Line 75735: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

75731: SELECT xet.event_id event_id
75732: , 0 line_number
75733: , CASE r
75734: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75735: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

75732: , 0 line_number
75733: , CASE r
75734: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75735: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

75733: , CASE r
75734: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75735: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75741: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75741: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75742: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75743:
75744: ELSE null

Line 75741: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75741: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75742: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75743:
75744: ELSE null
75745: END object_name

Line 75742: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75741: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75742: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75743:
75744: ELSE null
75745: END object_name
75746: , CASE r

Line 75803: , AR_TRANSACTIONS_S_V h5

75799: , null source_meaning
75800: FROM xla_events_gt xet
75801: , AR_BILL_TO_CUSTOMERS_S_V h1
75802: , AR_BILL_TO_SITE_USES_S_V h2
75803: , AR_TRANSACTIONS_S_V h5
75804: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75805: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75806: AND xet.event_class_code = C_EVENT_CLASS_CODE
75807: AND h1.event_id = xet.event_id

Line 76084: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

76080: --
76081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76082: --
76083:
76084: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
76085: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
76086: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76085: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

76081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76082: --
76083:
76084: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
76085: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
76086: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76089: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76086: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

76082: --
76083:
76084: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
76085: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
76086: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76089: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

76083:
76084: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
76085: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
76086: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76089: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

76086: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76089: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

76087: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76089: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76089: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76165: , AR_TRANSACTIONS_S_V h5

76161: , h5.TRX_DOC_SEQUENCE_ID source_120
76162: FROM xla_events_gt xet
76163: , AR_BILL_TO_CUSTOMERS_S_V h1
76164: , AR_BILL_TO_SITE_USES_S_V h2
76165: , AR_TRANSACTIONS_S_V h5
76166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76167: and xet.event_class_code = C_EVENT_CLASS_CODE
76168: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
76169: AND h2.event_id = h1.event_id

Line 77023: WHEN 12 THEN 'AR_TRANSACTIONS_S_V'

77019: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'
77020: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
77021: WHEN 10 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77022: WHEN 11 THEN 'AR_BILL_TO_SITE_USES_S_V'
77023: WHEN 12 THEN 'AR_TRANSACTIONS_S_V'
77024: WHEN 13 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77025: WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77026: WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77027: WHEN 16 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 77126: , AR_TRANSACTIONS_S_V h4

77122: FROM xla_events_gt xet
77123: , AR_BILL_TO_CUSTOMERS_S_V h1
77124: , AR_BILL_TO_SITE_USES_S_V h2
77125: , AR_REMIT_BANK_ACCT_H_V h3
77126: , AR_TRANSACTIONS_S_V h4
77127: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
77128: , fnd_lookup_values fvl124
77129: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77520: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

77516: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
77517: TYPE t_array_source_19 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NUM%TYPE INDEX BY BINARY_INTEGER;
77518: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
77519: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
77520: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
77521: TYPE t_array_source_93 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_121 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_122 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
77524: TYPE t_array_source_123 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 77649: , AR_TRANSACTIONS_S_V h4

77645: FROM xla_events_gt xet
77646: , AR_BILL_TO_CUSTOMERS_S_V h1
77647: , AR_BILL_TO_SITE_USES_S_V h2
77648: , AR_REMIT_BANK_ACCT_H_V h3
77649: , AR_TRANSACTIONS_S_V h4
77650: , JL_BR_AR_COLL_OCC_DOCS_H_V h6
77651: , fnd_lookup_values fvl124
77652: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77653: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78833: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

78829: FROM (
78830: SELECT xet.event_id event_id
78831: , 0 line_number
78832: , CASE r
78833: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78834: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

Line 78834: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

78830: SELECT xet.event_id event_id
78831: , 0 line_number
78832: , CASE r
78833: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78834: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

78831: , 0 line_number
78832: , CASE r
78833: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78834: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

78832: , CASE r
78833: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78834: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
78840: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
78840: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
78841: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
78842:
78843: ELSE null

Line 78840: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
78840: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
78841: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
78842:
78843: ELSE null
78844: END object_name

Line 78841: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
78840: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
78841: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
78842:
78843: ELSE null
78844: END object_name
78845: , CASE r

Line 78902: , AR_TRANSACTIONS_S_V h5

78898: , null source_meaning
78899: FROM xla_events_gt xet
78900: , AR_BILL_TO_CUSTOMERS_S_V h1
78901: , AR_BILL_TO_SITE_USES_S_V h2
78902: , AR_TRANSACTIONS_S_V h5
78903: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
78904: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78905: AND xet.event_class_code = C_EVENT_CLASS_CODE
78906: AND h1.event_id = xet.event_id

Line 79183: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

79179: --
79180: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79181: --
79182:
79183: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79184: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79185: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79184: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

79180: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79181: --
79182:
79183: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79184: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79185: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
79188: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79185: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79181: --
79182:
79183: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79184: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79185: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
79188: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

79182:
79183: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
79184: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79185: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
79188: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

79185: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
79188: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

79186: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
79188: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
79188: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79264: , AR_TRANSACTIONS_S_V h5

79260: , h5.TRX_DOC_SEQUENCE_ID source_120
79261: FROM xla_events_gt xet
79262: , AR_BILL_TO_CUSTOMERS_S_V h1
79263: , AR_BILL_TO_SITE_USES_S_V h2
79264: , AR_TRANSACTIONS_S_V h5
79265: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79266: and xet.event_class_code = C_EVENT_CLASS_CODE
79267: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
79268: AND h2.event_id = h1.event_id

Line 80111: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

80107: FROM (
80108: SELECT xet.event_id event_id
80109: , 0 line_number
80110: , CASE r
80111: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
80112: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

Line 80112: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

80108: SELECT xet.event_id event_id
80109: , 0 line_number
80110: , CASE r
80111: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
80112: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

80109: , 0 line_number
80110: , CASE r
80111: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
80112: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

80110: , CASE r
80111: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
80112: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
80118: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
80118: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
80119: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
80120:
80121: ELSE null

Line 80118: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
80118: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
80119: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
80120:
80121: ELSE null
80122: END object_name

Line 80119: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
80118: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
80119: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
80120:
80121: ELSE null
80122: END object_name
80123: , CASE r

Line 80180: , AR_TRANSACTIONS_S_V h5

80176: , null source_meaning
80177: FROM xla_events_gt xet
80178: , AR_BILL_TO_CUSTOMERS_S_V h1
80179: , AR_BILL_TO_SITE_USES_S_V h2
80180: , AR_TRANSACTIONS_S_V h5
80181: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
80182: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80183: AND xet.event_class_code = C_EVENT_CLASS_CODE
80184: AND h1.event_id = xet.event_id

Line 80471: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

80467: --
80468: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
80469: --
80470:
80471: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
80472: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80473: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80472: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

80468: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
80469: --
80470:
80471: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
80472: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80473: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
80476: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80473: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

80469: --
80470:
80471: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
80472: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80473: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
80476: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

80470:
80471: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
80472: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80473: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
80476: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

80473: TYPE t_array_source_5 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
80476: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

80474: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
80476: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
80476: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80556: , AR_TRANSACTIONS_S_V h5

80552: , h5.TRX_DOC_SEQUENCE_ID source_120
80553: FROM xla_events_gt xet
80554: , AR_BILL_TO_CUSTOMERS_S_V h1
80555: , AR_BILL_TO_SITE_USES_S_V h2
80556: , AR_TRANSACTIONS_S_V h5
80557: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80558: and xet.event_class_code = C_EVENT_CLASS_CODE
80559: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
80560: AND h2.event_id = h1.event_id

Line 83398: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

83394: FROM (
83395: SELECT xet.event_id event_id
83396: , l4.line_number line_number
83397: , CASE r
83398: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'

83395: SELECT xet.event_id event_id
83396: , l4.line_number line_number
83397: , CASE r
83398: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

83396: , l4.line_number line_number
83397: , CASE r
83398: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'

83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'

83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83574: , AR_TRANSACTIONS_S_V l10

83570: , AR_CUST_TRX_LINES_L_V l2
83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83574: , AR_TRANSACTIONS_S_V l10
83575: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
83576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83577: AND xet.event_class_code = C_EVENT_CLASS_CODE
83578: AND l3.event_id = xet.event_id

Line 83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

83736: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

83737: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

83738: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83953: , AR_TRANSACTIONS_S_V l10

83949: , AR_CUST_TRX_LINES_L_V l2
83950: , AR_DISTRIBUTIONS_BASE_V l3
83951: , AR_DISTRIBUTIONS_L_V l4
83952: , AR_RECEIVABLES_TRX_ACT_S_V l7
83953: , AR_TRANSACTIONS_S_V l10
83954: WHERE xet.event_id between x_first_event_id and x_last_event_id
83955: and xet.event_date between p_pad_start_date and p_pad_end_date
83956: and xet.event_class_code = C_EVENT_CLASS_CODE
83957: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id