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 JL_BR_AR_COLL_OCC_DOCS_H_V

Line 70682: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

70678: FROM (
70679: SELECT xet.event_id event_id
70680: , 0 line_number
70681: , CASE r
70682: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'

Line 70683: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

70679: SELECT xet.event_id event_id
70680: , 0 line_number
70681: , CASE r
70682: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'

Line 70684: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

70680: , 0 line_number
70681: , CASE r
70682: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'

Line 70694: WHEN 13 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'
70698: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 70695: WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'
70698: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70699:

Line 70696: WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_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'
70698: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70699:
70700: ELSE null

Line 70697: WHEN 16 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_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'
70698: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70699:
70700: ELSE null
70701: END object_name

Line 70698: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_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'
70698: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
70699:
70700: ELSE null
70701: END object_name
70702: , CASE r

Line 70797: , JL_BR_AR_COLL_OCC_DOCS_H_V h6

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
70801: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71174: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;

71170: --
71171: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71172: --
71173:
71174: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%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;

Line 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;

71171: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71172: --
71173:
71174: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%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;

Line 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;

71172: --
71173:
71174: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%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;

Line 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;

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;
71190: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 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;

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;
71190: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
71191:

Line 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;

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;
71190: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
71191:
71192: TYPE t_array_source_13 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 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;

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;
71190: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
71191:
71192: TYPE t_array_source_13 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
71193: TYPE t_array_source_25 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 71190: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%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;
71190: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
71191:
71192: TYPE t_array_source_13 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
71193: TYPE t_array_source_25 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
71194: TYPE t_array_source_26 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 71313: , JL_BR_AR_COLL_OCC_DOCS_H_V h6

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
71317: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id

Line 77012: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

77008: FROM (
77009: SELECT xet.event_id event_id
77010: , 0 line_number
77011: , CASE r
77012: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'

Line 77013: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

77009: SELECT xet.event_id event_id
77010: , 0 line_number
77011: , CASE r
77012: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'

Line 77014: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

77010: , 0 line_number
77011: , CASE r
77012: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'

Line 77024: WHEN 13 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'
77028: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 77025: WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_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'
77028: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77029:

Line 77026: WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_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'
77028: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77029:
77030: ELSE null

Line 77027: WHEN 16 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_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'
77028: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77029:
77030: ELSE null
77031: END object_name

Line 77028: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_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'
77028: WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
77029:
77030: ELSE null
77031: END object_name
77032: , CASE r

Line 77127: , JL_BR_AR_COLL_OCC_DOCS_H_V h6

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
77131: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77509: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;

77505: --
77506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77507: --
77508:
77509: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%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;

Line 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;

77506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77507: --
77508:
77509: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%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;

Line 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;

77507: --
77508:
77509: TYPE t_array_source_10 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%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;

Line 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;

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;
77525: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 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;

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;
77525: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
77526:

Line 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;

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;
77525: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
77526:
77527: TYPE t_array_source_13 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 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;

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;
77525: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
77526:
77527: TYPE t_array_source_13 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_25 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 77525: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%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;
77525: TYPE t_array_source_124 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
77526:
77527: TYPE t_array_source_13 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_25 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_27 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 77650: , JL_BR_AR_COLL_OCC_DOCS_H_V h6

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
77654: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id