eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00222_AAD_S_000017_PKG dependencies on JL_BR_AR_COLL_OCC_DOCS_H_V

Line 67103: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67099: FROM (
67100: SELECT xet.event_id event_id
67101: , 0 line_number
67102: , CASE r
67103: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67104: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67105: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67106: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 67104: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67100: SELECT xet.event_id event_id
67101: , 0 line_number
67102: , CASE r
67103: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67104: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67105: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67106: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 67105: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67101: , 0 line_number
67102: , CASE r
67103: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67104: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67105: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67106: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

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

Line 67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67106: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67112: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67113: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67114:

Line 67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67112: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67113: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67114:
67115: ELSE null

Line 67112: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67108: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67112: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67113: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67114:
67115: ELSE null
67116: END object_name

Line 67113: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

67109: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67112: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67113: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67114:
67115: ELSE null
67116: END object_name
67117: , CASE r

Line 67187: , JL_BR_AR_COLL_OCC_DOCS_H_V h5

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

Line 67563: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;

67559: --
67560: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67561: --
67562:
67563: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
67564: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67565: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67566: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67567: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 67564: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

67560: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67561: --
67562:
67563: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
67564: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67565: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67566: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67567: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 67565: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

67561: --
67562:
67563: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
67564: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67565: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
67566: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67567: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 67570: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

67566: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67567: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67570: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:

Line 67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

67567: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67570: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;

67568: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67570: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;

67569: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67570: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 67683: , JL_BR_AR_COLL_OCC_DOCS_H_V h5

67679: FROM xla_events_gt xet
67680: , AR_BILL_TO_CUSTOMERS_S_V h1
67681: , AR_BILL_TO_SITE_USES_S_V h2
67682: , AR_TRANSACTIONS_S_V h3
67683: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67684: , fnd_lookup_values fvl116
67685: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67686: and xet.event_class_code = C_EVENT_CLASS_CODE
67687: and xet.event_status_code <> 'N' AND h5.event_id = xet.event_id

Line 73210: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73206: FROM (
73207: SELECT xet.event_id event_id
73208: , 0 line_number
73209: , CASE r
73210: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73211: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73212: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73213: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

Line 73211: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73207: SELECT xet.event_id event_id
73208: , 0 line_number
73209: , CASE r
73210: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73211: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73212: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73213: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 73212: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73208: , 0 line_number
73209: , CASE r
73210: WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73211: WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73212: WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73213: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

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

Line 73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73213: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73219: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73220: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73221:

Line 73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73219: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73220: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73221:
73222: ELSE null

Line 73219: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73215: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73219: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73220: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73221:
73222: ELSE null
73223: END object_name

Line 73220: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

73216: WHEN 7 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73219: WHEN 10 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73220: WHEN 11 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73221:
73222: ELSE null
73223: END object_name
73224: , CASE r

Line 73294: , JL_BR_AR_COLL_OCC_DOCS_H_V h5

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

Line 73675: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;

73671: --
73672: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73673: --
73674:
73675: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
73676: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73677: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73678: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73679: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73676: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

73672: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73673: --
73674:
73675: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
73676: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73677: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73678: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73679: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73677: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

73673: --
73674:
73675: TYPE t_array_source_4 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_BANK_OCC_DESC%TYPE INDEX BY BINARY_INTEGER;
73676: TYPE t_array_source_5 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73677: TYPE t_array_source_6 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRADE_NOTE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
73678: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73679: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 73682: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

73678: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73679: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73682: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:

Line 73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

73679: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73682: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;

73680: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73682: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;

73681: TYPE t_array_source_82 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73682: TYPE t_array_source_113 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73797: , JL_BR_AR_COLL_OCC_DOCS_H_V h5

73793: FROM xla_events_gt xet
73794: , AR_BILL_TO_CUSTOMERS_S_V h1
73795: , AR_BILL_TO_SITE_USES_S_V h2
73796: , AR_TRANSACTIONS_S_V h3
73797: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73798: , fnd_lookup_values fvl116
73799: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73800: and xet.event_class_code = C_EVENT_CLASS_CODE
73801: and xet.event_status_code <> 'N' AND h5.event_id = xet.event_id