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_REMIT_BANK_ACCT_H_V

Line 70687: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

70683: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70684: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70685: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70686: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70687: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
70688: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 70688: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

70684: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70685: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70686: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70687: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
70688: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 70689: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'

70685: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70686: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70687: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
70688: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 70690: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'

70686: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70687: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
70688: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 70795: , AR_REMIT_BANK_ACCT_H_V h3

70791: END source_meaning
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)

Line 71179: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

71175: TYPE t_array_source_11 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71176: TYPE t_array_source_12 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71177: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
71178: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71179: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
71180: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 71180: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%TYPE INDEX BY BINARY_INTEGER;

71176: TYPE t_array_source_12 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71177: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
71178: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71179: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
71180: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 71181: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

71177: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
71178: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71179: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
71180: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 71182: TYPE t_array_source_19 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NUM%TYPE INDEX BY BINARY_INTEGER;

71178: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
71179: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
71180: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 71311: , AR_REMIT_BANK_ACCT_H_V h3

71307: , fvl124.meaning source_124_meaning
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

Line 77017: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'

77013: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77014: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77015: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77016: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77017: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77018: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 77018: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'

77014: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77015: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77016: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77017: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77018: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 77019: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'

77015: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77016: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77017: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77018: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 77020: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'

77016: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
77017: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77018: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_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'

Line 77125: , AR_REMIT_BANK_ACCT_H_V h3

77121: END source_meaning
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)

Line 77514: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

77510: TYPE t_array_source_11 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77511: TYPE t_array_source_12 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77512: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
77513: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77514: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
77515: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 77515: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%TYPE INDEX BY BINARY_INTEGER;

77511: TYPE t_array_source_12 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77512: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
77513: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77514: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
77515: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 77516: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

77512: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
77513: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77514: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
77515: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 77517: TYPE t_array_source_19 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NUM%TYPE INDEX BY BINARY_INTEGER;

77513: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
77514: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
77515: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NUM%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;

Line 77648: , AR_REMIT_BANK_ACCT_H_V h3

77644: , fvl124.meaning source_124_meaning
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

Line 81735: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

81731: FROM (
81732: SELECT xet.event_id event_id
81733: , 0 line_number
81734: , CASE r
81735: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

Line 81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

81732: SELECT xet.event_id event_id
81733: , 0 line_number
81734: , CASE r
81735: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
81736: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
81737: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
81738: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
81739: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
81740: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'

Line 81804: , AR_REMIT_BANK_ACCT_H_V h5

81800: , null source_meaning
81801: FROM xla_events_gt xet
81802: , AR_CASH_RECEIPTS_H_V h1
81803: , AR_RCT_METHOD_H_V h4
81804: , AR_REMIT_BANK_ACCT_H_V h5
81805: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
81806: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81807: AND xet.event_class_code = C_EVENT_CLASS_CODE
81808:

Line 82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

82088: --
82089: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
82090: --
82091:
82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

82089: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
82090: --
82091:
82092: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
82093: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
82094: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82095: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
82096: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
82097: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 82177: , AR_REMIT_BANK_ACCT_H_V h5

82173: , h1.RCT_TRX_ACCT_REVERSAL source_127
82174: FROM xla_events_gt xet
82175: , AR_CASH_RECEIPTS_H_V h1
82176: , AR_RCT_METHOD_H_V h4
82177: , AR_REMIT_BANK_ACCT_H_V h5
82178: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
82179: and xet.event_class_code = C_EVENT_CLASS_CODE
82180: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
82181: AND h4.event_id (+) = xet.event_id

Line 83202: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

83198: FROM (
83199: SELECT xet.event_id event_id
83200: , 0 line_number
83201: , CASE r
83202: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

Line 83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

83199: SELECT xet.event_id event_id
83200: , 0 line_number
83201: , CASE r
83202: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
83203: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'

83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'

Line 83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'

83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
83214: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
83215: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83322: , AR_REMIT_BANK_ACCT_H_V h8

83318: FROM xla_events_gt xet
83319: , AR_CASH_RECEIPTS_H_V h1
83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83323: , AR_SYSTEM_PARAM_H_V h9
83324: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
83325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83326: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

83716: --
83717: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83718: --
83719:
83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

83717: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83718: --
83719:
83720: TYPE t_array_source_16 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
83721: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;

83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
83732: TYPE t_array_source_113 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
83733: TYPE t_array_source_114 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 83874: , AR_REMIT_BANK_ACCT_H_V h8

83870: FROM xla_events_gt xet
83871: , AR_CASH_RECEIPTS_H_V h1
83872: , AR_RCT_METHOD_H_V h5
83873: , AR_RCT_SITE_USES_H_V h6
83874: , AR_REMIT_BANK_ACCT_H_V h8
83875: , AR_SYSTEM_PARAM_H_V h9
83876: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83877: and xet.event_class_code = C_EVENT_CLASS_CODE
83878: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id