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 AR_BILL_TO_SITE_USES_S_V

Line 63051: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

63047: , 0 line_number
63048: , CASE r
63049: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
63050: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
63051: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
63052: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
63053: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'
63054: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
63055: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 63108: , AR_BILL_TO_SITE_USES_S_V h3

63104: , null source_meaning
63105: FROM xla_events_gt xet
63106: , AR_ADJUSTMENTS_H_V h1
63107: , AR_BILL_TO_CUSTOMERS_S_V h2
63108: , AR_BILL_TO_SITE_USES_S_V h3
63109: , AR_RECEIVABLES_TRX_ACT_S_V h6
63110: , AR_TRANSACTIONS_S_V h7
63111: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
63112: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

63396: --
63397:
63398: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
63399: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
63400: 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;
63401: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
63402: TYPE t_array_source_107 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
63403: TYPE t_array_source_108 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
63404: TYPE t_array_source_109 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 63475: , AR_BILL_TO_SITE_USES_S_V h3

63471: , h1.ADJ_DOC_SEQUENCE_VALUE source_109
63472: FROM xla_events_gt xet
63473: , AR_ADJUSTMENTS_H_V h1
63474: , AR_BILL_TO_CUSTOMERS_S_V h2
63475: , AR_BILL_TO_SITE_USES_S_V h3
63476: , AR_RECEIVABLES_TRX_ACT_S_V h6
63477: , AR_TRANSACTIONS_S_V h7
63478: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63479: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

65855: , 0 line_number
65856: , CASE r
65857: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
65858: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
65859: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
65860: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
65861: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
65862: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
65863: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 65915: , AR_BILL_TO_SITE_USES_S_V h2

65911: END source_value
65912: , null source_meaning
65913: FROM xla_events_gt xet
65914: , AR_BILL_TO_CUSTOMERS_S_V h1
65915: , AR_BILL_TO_SITE_USES_S_V h2
65916: , AR_TRANSACTIONS_S_V h5
65917: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
65918: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65919: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

66195: --
66196:
66197: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66198: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66199: 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;
66200: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66201: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66202: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66203: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 66271: , AR_BILL_TO_SITE_USES_S_V h2

66267: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
66268: , h5.TRX_DOC_SEQUENCE_ID source_112
66269: FROM xla_events_gt xet
66270: , AR_BILL_TO_CUSTOMERS_S_V h1
66271: , AR_BILL_TO_SITE_USES_S_V h2
66272: , AR_TRANSACTIONS_S_V h5
66273: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66274: and xet.event_class_code = C_EVENT_CLASS_CODE
66275: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 67107: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
67110: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
67111: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 67185: , AR_BILL_TO_SITE_USES_S_V h2

67181: ELSE null
67182: END source_meaning
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)

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

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

Line 67681: , AR_BILL_TO_SITE_USES_S_V h2

67677: , h5.JLBR_TRANSFER_TO_GL_FLAG source_116
67678: , fvl116.meaning source_116_meaning
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

Line 70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

70502: , 0 line_number
70503: , CASE r
70504: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
70505: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
70506: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
70507: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
70508: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
70509: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
70510: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 70562: , AR_BILL_TO_SITE_USES_S_V h2

70558: END source_value
70559: , null source_meaning
70560: FROM xla_events_gt xet
70561: , AR_BILL_TO_CUSTOMERS_S_V h1
70562: , AR_BILL_TO_SITE_USES_S_V h2
70563: , AR_TRANSACTIONS_S_V h5
70564: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
70565: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70566: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

70852: --
70853:
70854: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70856: 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;
70857: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 70932: , AR_BILL_TO_SITE_USES_S_V h2

70928: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
70929: , h5.TRX_DOC_SEQUENCE_ID source_112
70930: FROM xla_events_gt xet
70931: , AR_BILL_TO_CUSTOMERS_S_V h1
70932: , AR_BILL_TO_SITE_USES_S_V h2
70933: , AR_TRANSACTIONS_S_V h5
70934: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70935: and xet.event_class_code = C_EVENT_CLASS_CODE
70936: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

71962: , 0 line_number
71963: , CASE r
71964: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71965: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71966: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71967: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71968: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71969: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71970: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 72022: , AR_BILL_TO_SITE_USES_S_V h2

72018: END source_value
72019: , null source_meaning
72020: FROM xla_events_gt xet
72021: , AR_BILL_TO_CUSTOMERS_S_V h1
72022: , AR_BILL_TO_SITE_USES_S_V h2
72023: , AR_TRANSACTIONS_S_V h5
72024: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72025: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72026: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

72302: --
72303:
72304: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72306: 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;
72307: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72309: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72310: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72378: , AR_BILL_TO_SITE_USES_S_V h2

72374: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
72375: , h5.TRX_DOC_SEQUENCE_ID source_112
72376: FROM xla_events_gt xet
72377: , AR_BILL_TO_CUSTOMERS_S_V h1
72378: , AR_BILL_TO_SITE_USES_S_V h2
72379: , AR_TRANSACTIONS_S_V h5
72380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72381: and xet.event_class_code = C_EVENT_CLASS_CODE
72382: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 73214: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
73217: WHEN 8 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
73218: WHEN 9 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 73292: , AR_BILL_TO_SITE_USES_S_V h2

73288: ELSE null
73289: END source_meaning
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)

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

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

Line 73795: , AR_BILL_TO_SITE_USES_S_V h2

73791: , h5.JLBR_TRANSFER_TO_GL_FLAG source_116
73792: , fvl116.meaning source_116_meaning
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

Line 74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

74948: , 0 line_number
74949: , CASE r
74950: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
74951: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74952: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
74953: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74954: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74955: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
74956: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 75008: , AR_BILL_TO_SITE_USES_S_V h2

75004: END source_value
75005: , null source_meaning
75006: FROM xla_events_gt xet
75007: , AR_BILL_TO_CUSTOMERS_S_V h1
75008: , AR_BILL_TO_SITE_USES_S_V h2
75009: , AR_TRANSACTIONS_S_V h5
75010: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75011: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75012: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

75288: --
75289:
75290: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75291: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75292: 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;
75293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75294: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75295: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75296: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75364: , AR_BILL_TO_SITE_USES_S_V h2

75360: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
75361: , h5.TRX_DOC_SEQUENCE_ID source_112
75362: FROM xla_events_gt xet
75363: , AR_BILL_TO_CUSTOMERS_S_V h1
75364: , AR_BILL_TO_SITE_USES_S_V h2
75365: , AR_TRANSACTIONS_S_V h5
75366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75367: and xet.event_class_code = C_EVENT_CLASS_CODE
75368: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

76194: , 0 line_number
76195: , CASE r
76196: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
76197: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
76198: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
76199: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
76200: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
76201: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
76202: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 76254: , AR_BILL_TO_SITE_USES_S_V h2

76250: END source_value
76251: , null source_meaning
76252: FROM xla_events_gt xet
76253: , AR_BILL_TO_CUSTOMERS_S_V h1
76254: , AR_BILL_TO_SITE_USES_S_V h2
76255: , AR_TRANSACTIONS_S_V h5
76256: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
76257: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76258: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

76549: --
76550:
76551: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76552: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76553: 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;
76554: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76555: TYPE t_array_source_47 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76556: TYPE t_array_source_111 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76557: TYPE t_array_source_112 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76631: , AR_BILL_TO_SITE_USES_S_V h2

76627: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
76628: , h5.TRX_DOC_SEQUENCE_ID source_112
76629: FROM xla_events_gt xet
76630: , AR_BILL_TO_CUSTOMERS_S_V h1
76631: , AR_BILL_TO_SITE_USES_S_V h2
76632: , AR_TRANSACTIONS_S_V h5
76633: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76634: and xet.event_class_code = C_EVENT_CLASS_CODE
76635: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id