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_BILL_TO_CUSTOMERS_S_V

Line 66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

66545: , CASE r
66546: WHEN 1 THEN 'AR_ADJUSTMENTS_H_V'
66547: WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'
66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
66552: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
66553: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'

Line 66609: , AR_BILL_TO_CUSTOMERS_S_V h2

66605: END source_value
66606: , null source_meaning
66607: FROM xla_events_gt xet
66608: , AR_ADJUSTMENTS_H_V h1
66609: , AR_BILL_TO_CUSTOMERS_S_V h2
66610: , AR_BILL_TO_SITE_USES_S_V h3
66611: , AR_RECEIVABLES_TRX_ACT_S_V h6
66612: , AR_TRANSACTIONS_S_V h7
66613: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

Line 66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 66979: , AR_BILL_TO_CUSTOMERS_S_V h2

66975: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_117
66976: , h1.ADJ_DOC_SEQUENCE_ID source_118
66977: FROM xla_events_gt xet
66978: , AR_ADJUSTMENTS_H_V h1
66979: , AR_BILL_TO_CUSTOMERS_S_V h2
66980: , AR_BILL_TO_SITE_USES_S_V h3
66981: , AR_RECEIVABLES_TRX_ACT_S_V h6
66982: , AR_TRANSACTIONS_S_V h7
66983: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

69404: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69405: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69406: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69407: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69408: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
69410: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
69411: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
69412: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 69471: , AR_BILL_TO_CUSTOMERS_S_V h1

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

Line 69758: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 69833: , AR_BILL_TO_CUSTOMERS_S_V h1

69829: , h5.XLA_PARTY_TYPE source_51
69830: , h5.TRX_INVOICE_CURRENCY_CODE source_59
69831: , h5.TRX_DOC_SEQUENCE_ID source_120
69832: FROM xla_events_gt xet
69833: , AR_BILL_TO_CUSTOMERS_S_V h1
69834: , AR_BILL_TO_SITE_USES_S_V h2
69835: , AR_TRANSACTIONS_S_V h5
69836: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69837: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 70685: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
70689: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 70686: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
70689: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'
70690: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 70691: WHEN 10 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'
70695: WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 70793: , AR_BILL_TO_CUSTOMERS_S_V h1

70789:
70790: ELSE null
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

Line 71177: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;

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;
71181: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 71178: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

Line 71183: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%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;
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;

Line 71309: , AR_BILL_TO_CUSTOMERS_S_V h1

71305: , h6.JLBR_GL_DATE source_123
71306: , h6.JLBR_TRANSFER_TO_GL_FLAG source_124
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

Line 74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

74221: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74222: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
74223: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74224: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74225: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
74227: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
74228: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
74229: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 74288: , AR_BILL_TO_CUSTOMERS_S_V h1

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

Line 74580: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 74657: , AR_BILL_TO_CUSTOMERS_S_V h1

74653: , h5.XLA_PARTY_TYPE source_51
74654: , h5.TRX_INVOICE_CURRENCY_CODE source_59
74655: , h5.TRX_DOC_SEQUENCE_ID source_120
74656: FROM xla_events_gt xet
74657: , AR_BILL_TO_CUSTOMERS_S_V h1
74658: , AR_BILL_TO_SITE_USES_S_V h2
74659: , AR_TRANSACTIONS_S_V h5
74660: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74661: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

75734: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75735: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
75736: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75737: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
75738: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
75740: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75741: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75742: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 75801: , AR_BILL_TO_CUSTOMERS_S_V h1

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

Line 76088: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 76163: , AR_BILL_TO_CUSTOMERS_S_V h1

76159: , h5.XLA_PARTY_TYPE source_51
76160: , h5.TRX_INVOICE_CURRENCY_CODE source_59
76161: , h5.TRX_DOC_SEQUENCE_ID source_120
76162: FROM xla_events_gt xet
76163: , AR_BILL_TO_CUSTOMERS_S_V h1
76164: , AR_BILL_TO_SITE_USES_S_V h2
76165: , AR_TRANSACTIONS_S_V h5
76166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76167: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77015: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
77019: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 77016: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

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'
77019: WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'
77020: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 77021: WHEN 10 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'
77025: WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 77123: , AR_BILL_TO_CUSTOMERS_S_V h1

77119:
77120: ELSE null
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

Line 77512: TYPE t_array_source_14 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;

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;
77516: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 77513: TYPE t_array_source_15 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

Line 77518: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%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;
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;

Line 77646: , AR_BILL_TO_CUSTOMERS_S_V h1

77642: , h6.JLBR_GL_DATE source_123
77643: , h6.JLBR_TRANSFER_TO_GL_FLAG source_124
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

Line 78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

78833: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
78834: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
78835: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78836: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
78837: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
78839: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
78840: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
78841: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 78900: , AR_BILL_TO_CUSTOMERS_S_V h1

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

Line 79187: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 79262: , AR_BILL_TO_CUSTOMERS_S_V h1

79258: , h5.XLA_PARTY_TYPE source_51
79259: , h5.TRX_INVOICE_CURRENCY_CODE source_59
79260: , h5.TRX_DOC_SEQUENCE_ID source_120
79261: FROM xla_events_gt xet
79262: , AR_BILL_TO_CUSTOMERS_S_V h1
79263: , AR_BILL_TO_SITE_USES_S_V h2
79264: , AR_TRANSACTIONS_S_V h5
79265: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79266: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

80111: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
80112: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
80113: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
80114: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
80115: WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_S_V'
80117: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
80118: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
80119: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 80178: , AR_BILL_TO_CUSTOMERS_S_V h1

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

Line 80475: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

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

Line 80554: , AR_BILL_TO_CUSTOMERS_S_V h1

80550: , h5.XLA_PARTY_TYPE source_51
80551: , h5.TRX_INVOICE_CURRENCY_CODE source_59
80552: , h5.TRX_DOC_SEQUENCE_ID source_120
80553: FROM xla_events_gt xet
80554: , AR_BILL_TO_CUSTOMERS_S_V h1
80555: , AR_BILL_TO_SITE_USES_S_V h2
80556: , AR_TRANSACTIONS_S_V h5
80557: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80558: and xet.event_class_code = C_EVENT_CLASS_CODE