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_SITE_USES_S_V

Line 66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
66554:

Line 66610: , AR_BILL_TO_SITE_USES_S_V h3

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)
66614: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

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

Line 66980: , AR_BILL_TO_SITE_USES_S_V h3

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
66984: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 69409: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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'
69413:

Line 69472: , AR_BILL_TO_SITE_USES_S_V h2

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

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

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

Line 69834: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 70692: WHEN 11 THEN 'AR_BILL_TO_SITE_USES_S_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'
70696: WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 70794: , AR_BILL_TO_SITE_USES_S_V h2

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
70798: , fnd_lookup_values fvl124

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

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

Line 71310: , AR_BILL_TO_SITE_USES_S_V h2

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
71314: , fnd_lookup_values fvl124

Line 74226: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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'
74230:

Line 74289: , AR_BILL_TO_SITE_USES_S_V h2

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

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

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

Line 74658: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 75739: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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'
75743:

Line 75802: , AR_BILL_TO_SITE_USES_S_V h2

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

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

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

Line 76164: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 77022: WHEN 11 THEN 'AR_BILL_TO_SITE_USES_S_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'
77026: WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'

Line 77124: , AR_BILL_TO_SITE_USES_S_V h2

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
77128: , fnd_lookup_values fvl124

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

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

Line 77647: , AR_BILL_TO_SITE_USES_S_V h2

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
77651: , fnd_lookup_values fvl124

Line 78838: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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'
78842:

Line 78901: , AR_BILL_TO_SITE_USES_S_V h2

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

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

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

Line 79263: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 80116: WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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'
80120:

Line 80179: , AR_BILL_TO_SITE_USES_S_V h2

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

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

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

Line 80555: , AR_BILL_TO_SITE_USES_S_V h2

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