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.

[Home] [Help]

APPS.XLA_00222_AAD_S_000009_PKG dependencies on AR_TRANSACTIONS_S_V

Line 67699: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

67695: FROM (
67696: SELECT xet.event_id event_id
67697: , 0 line_number
67698: , CASE r
67699: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
67700: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
67701: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67702: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
67703: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 67703: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

67699: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
67700: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
67701: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67702: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
67703: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
67704: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
67705: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
67706: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
67707:

Line 67765: , AR_TRANSACTIONS_S_V h7

67761: , AR_ADJUSTMENTS_H_V h1
67762: , AR_BILL_TO_CUSTOMERS_S_V h2
67763: , AR_BILL_TO_SITE_USES_S_V h3
67764: , AR_RECEIVABLES_TRX_ACT_S_V h6
67765: , AR_TRANSACTIONS_S_V h7
67766: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
67767: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67768: AND xet.event_class_code = C_EVENT_CLASS_CODE
67769: AND h1.event_id = xet.event_id

Line 68053: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

68049: --
68050: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68051: --
68052:
68053: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
68054: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
68055: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68056: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68057: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68057: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

68053: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
68054: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
68055: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68056: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68057: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68058: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68059: TYPE t_array_source_82 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68060: TYPE t_array_source_83 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68061:

Line 68135: , AR_TRANSACTIONS_S_V h7

68131: , AR_ADJUSTMENTS_H_V h1
68132: , AR_BILL_TO_CUSTOMERS_S_V h2
68133: , AR_BILL_TO_SITE_USES_S_V h3
68134: , AR_RECEIVABLES_TRX_ACT_S_V h6
68135: , AR_TRANSACTIONS_S_V h7
68136: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68137: and xet.event_class_code = C_EVENT_CLASS_CODE
68138: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
68139: AND h2.event_id = h1.event_id

Line 69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

69067: , 0 line_number
69068: , CASE r
69069: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
69075: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

69068: , CASE r
69069: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
69075: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69076:

Line 69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

69069: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
69075: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69076:
69077: ELSE null

Line 69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
69075: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69076:
69077: ELSE null
69078: END object_name

Line 69075: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
69075: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69076:
69077: ELSE null
69078: END object_name
69079: , CASE r

Line 69128: , AR_TRANSACTIONS_S_V h5

69124: , null source_meaning
69125: FROM xla_events_gt xet
69126: , AR_BILL_TO_CUSTOMERS_S_V h1
69127: , AR_BILL_TO_SITE_USES_S_V h2
69128: , AR_TRANSACTIONS_S_V h5
69129: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
69130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69131: AND xet.event_class_code = C_EVENT_CLASS_CODE
69132: AND h1.event_id = xet.event_id

Line 69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

69407: --
69408:
69409: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

69408:
69409: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:

Line 69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

69409: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69484: , AR_TRANSACTIONS_S_V h5

69480: , h5.TRX_DOC_SEQUENCE_VALUE source_87
69481: FROM xla_events_gt xet
69482: , AR_BILL_TO_CUSTOMERS_S_V h1
69483: , AR_BILL_TO_SITE_USES_S_V h2
69484: , AR_TRANSACTIONS_S_V h5
69485: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69486: and xet.event_class_code = C_EVENT_CLASS_CODE
69487: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
69488: AND h2.event_id = h1.event_id

Line 71934: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

71930: FROM (
71931: SELECT xet.event_id event_id
71932: , 0 line_number
71933: , CASE r
71934: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

71933: , CASE r
71934: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

71934: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
71942: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
71942: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
71943:

Line 71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
71942: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
71943:
71944: ELSE null

Line 71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
71942: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
71943:
71944: ELSE null
71945: END object_name

Line 71942: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
71941: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
71942: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
71943:
71944: ELSE null
71945: END object_name
71946: , CASE r

Line 72003: , AR_TRANSACTIONS_S_V h5

71999: , null source_meaning
72000: FROM xla_events_gt xet
72001: , AR_BILL_TO_CUSTOMERS_S_V h1
72002: , AR_BILL_TO_SITE_USES_S_V h2
72003: , AR_TRANSACTIONS_S_V h5
72004: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72005: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72006: AND xet.event_class_code = C_EVENT_CLASS_CODE
72007: AND h1.event_id = xet.event_id

Line 72289: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

72285: --
72286: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72287: --
72288:
72289: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

72288:
72289: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

72289: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:

Line 72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72372: , AR_TRANSACTIONS_S_V h5

72368: , h5.TRX_DOC_SEQUENCE_VALUE source_87
72369: FROM xla_events_gt xet
72370: , AR_BILL_TO_CUSTOMERS_S_V h1
72371: , AR_BILL_TO_SITE_USES_S_V h2
72372: , AR_TRANSACTIONS_S_V h5
72373: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72374: and xet.event_class_code = C_EVENT_CLASS_CODE
72375: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
72376: AND h2.event_id = h1.event_id

Line 73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

73403: , 0 line_number
73404: , CASE r
73405: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73411: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

73404: , CASE r
73405: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73411: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73412:

Line 73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

73405: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73411: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73412:
73413: ELSE null

Line 73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73411: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73412:
73413: ELSE null
73414: END object_name

Line 73411: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73411: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
73412:
73413: ELSE null
73414: END object_name
73415: , CASE r

Line 73464: , AR_TRANSACTIONS_S_V h5

73460: , null source_meaning
73461: FROM xla_events_gt xet
73462: , AR_BILL_TO_CUSTOMERS_S_V h1
73463: , AR_BILL_TO_SITE_USES_S_V h2
73464: , AR_TRANSACTIONS_S_V h5
73465: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73466: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73467: AND xet.event_class_code = C_EVENT_CLASS_CODE
73468: AND h1.event_id = xet.event_id

Line 73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

73743: --
73744:
73745: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

73744:
73745: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:

Line 73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

73745: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73820: , AR_TRANSACTIONS_S_V h5

73816: , h5.TRX_DOC_SEQUENCE_VALUE source_87
73817: FROM xla_events_gt xet
73818: , AR_BILL_TO_CUSTOMERS_S_V h1
73819: , AR_BILL_TO_SITE_USES_S_V h2
73820: , AR_TRANSACTIONS_S_V h5
73821: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73822: and xet.event_class_code = C_EVENT_CLASS_CODE
73823: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
73824: AND h2.event_id = h1.event_id

Line 74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'

74649: , 0 line_number
74650: , CASE r
74651: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74657: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'

74650: , CASE r
74651: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74657: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74658:

Line 74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

74651: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74657: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74658:
74659: ELSE null

Line 74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74657: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74658:
74659: ELSE null
74660: END object_name

Line 74657: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74657: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74658:
74659: ELSE null
74660: END object_name
74661: , CASE r

Line 74710: , AR_TRANSACTIONS_S_V h5

74706: , null source_meaning
74707: FROM xla_events_gt xet
74708: , AR_BILL_TO_CUSTOMERS_S_V h1
74709: , AR_BILL_TO_SITE_USES_S_V h2
74710: , AR_TRANSACTIONS_S_V h5
74711: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74713: AND xet.event_class_code = C_EVENT_CLASS_CODE
74714: AND h1.event_id = xet.event_id

Line 74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

74989: --
74990:
74991: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

74990:
74991: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:

Line 74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

74991: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75066: , AR_TRANSACTIONS_S_V h5

75062: , h5.TRX_DOC_SEQUENCE_VALUE source_87
75063: FROM xla_events_gt xet
75064: , AR_BILL_TO_CUSTOMERS_S_V h1
75065: , AR_BILL_TO_SITE_USES_S_V h2
75066: , AR_TRANSACTIONS_S_V h5
75067: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75068: and xet.event_class_code = C_EVENT_CLASS_CODE
75069: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
75070: AND h2.event_id = h1.event_id

Line 75897: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'

75893: FROM (
75894: SELECT xet.event_id event_id
75895: , 0 line_number
75896: , CASE r
75897: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

75897: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75906: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'

Line 75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75906: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
75907:

Line 75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75906: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
75907:
75908: ELSE null

Line 75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75906: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
75907:
75908: ELSE null
75909: END object_name

Line 75906: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'

75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75905: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
75906: WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
75907:
75908: ELSE null
75909: END object_name
75910: , CASE r

Line 75971: , AR_TRANSACTIONS_S_V h5

75967: , null source_meaning
75968: FROM xla_events_gt xet
75969: , AR_BILL_TO_CUSTOMERS_S_V h1
75970: , AR_BILL_TO_SITE_USES_S_V h2
75971: , AR_TRANSACTIONS_S_V h5
75972: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
75973: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75974: AND xet.event_class_code = C_EVENT_CLASS_CODE
75975: AND h1.event_id = xet.event_id

Line 76273: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

76269: --
76270: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76271: --
76272:
76273: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

76273: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76283:

Line 76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76283:
76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76283:
76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76283:
76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 76365: , AR_TRANSACTIONS_S_V h5

76361: , h5.TRX_DOC_SEQUENCE_VALUE source_87
76362: FROM xla_events_gt xet
76363: , AR_BILL_TO_CUSTOMERS_S_V h1
76364: , AR_BILL_TO_SITE_USES_S_V h2
76365: , AR_TRANSACTIONS_S_V h5
76366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76367: and xet.event_class_code = C_EVENT_CLASS_CODE
76368: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
76369: AND h2.event_id = h1.event_id

Line 79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'

79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'
79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
79539: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
79540: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79541: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
79542: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79539: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'

79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'
79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
79539: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
79540: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79541: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
79542: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
79543: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79717: , AR_TRANSACTIONS_S_V l11

79713: , AR_CUST_TRX_LINES_L_V l3
79714: , AR_DISTRIBUTIONS_BASE_V l4
79715: , AR_DISTRIBUTIONS_L_V l5
79716: , AR_RECEIVABLES_TRX_ACT_S_V l8
79717: , AR_TRANSACTIONS_S_V l11
79718: , FV_XLA_AR_REF_V l12
79719: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
79720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79721: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79910: TYPE t_array_source_62 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79911: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79912: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79913: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79910: TYPE t_array_source_62 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79910: TYPE t_array_source_62 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79911: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79912: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79913: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79914: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80115: , AR_TRANSACTIONS_S_V l11

80111: , AR_CUST_TRX_LINES_L_V l3
80112: , AR_DISTRIBUTIONS_BASE_V l4
80113: , AR_DISTRIBUTIONS_L_V l5
80114: , AR_RECEIVABLES_TRX_ACT_S_V l8
80115: , AR_TRANSACTIONS_S_V l11
80116: , FV_XLA_AR_REF_V l12
80117: WHERE xet.event_id between x_first_event_id and x_last_event_id
80118: and xet.event_date between p_pad_start_date and p_pad_end_date
80119: and xet.event_class_code = C_EVENT_CLASS_CODE