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_000005_PKG dependencies on AR_BILL_TO_SITE_USES_S_V

Line 66740: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

66736: , 0 line_number
66737: , CASE r
66738: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66739: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66740: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
66741: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
66742: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'
66743: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
66744: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 66797: , AR_BILL_TO_SITE_USES_S_V h3

66793: , null source_meaning
66794: FROM xla_events_gt xet
66795: , AR_ADJUSTMENTS_H_V h1
66796: , AR_BILL_TO_CUSTOMERS_S_V h2
66797: , AR_BILL_TO_SITE_USES_S_V h3
66798: , AR_RECEIVABLES_TRX_ACT_S_V h6
66799: , AR_TRANSACTIONS_S_V h7
66800: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
66801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 67089: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

67085: --
67086:
67087: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
67088: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67089: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67090: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67091: TYPE t_array_source_77 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
67092: TYPE t_array_source_78 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67093: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 67164: , AR_BILL_TO_SITE_USES_S_V h3

67160: , h1.ADJ_DOC_SEQUENCE_VALUE source_79
67161: FROM xla_events_gt xet
67162: , AR_ADJUSTMENTS_H_V h1
67163: , AR_BILL_TO_CUSTOMERS_S_V h2
67164: , AR_BILL_TO_SITE_USES_S_V h3
67165: , AR_RECEIVABLES_TRX_ACT_S_V h6
67166: , AR_TRANSACTIONS_S_V h7
67167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67168: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

68187: , 0 line_number
68188: , CASE r
68189: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68190: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68191: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
68192: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
68193: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68194: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
68195: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 68247: , AR_BILL_TO_SITE_USES_S_V h2

68243: END source_value
68244: , null source_meaning
68245: FROM xla_events_gt xet
68246: , AR_BILL_TO_CUSTOMERS_S_V h1
68247: , AR_BILL_TO_SITE_USES_S_V h2
68248: , AR_TRANSACTIONS_S_V h5
68249: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68250: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68251: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

68527: --
68528:
68529: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68530: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68531: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68532: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68603: , AR_BILL_TO_SITE_USES_S_V h2

68599: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
68600: , h5.TRX_DOC_SEQUENCE_ID source_82
68601: FROM xla_events_gt xet
68602: , AR_BILL_TO_CUSTOMERS_S_V h1
68603: , AR_BILL_TO_SITE_USES_S_V h2
68604: , AR_TRANSACTIONS_S_V h5
68605: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68606: and xet.event_class_code = C_EVENT_CLASS_CODE
68607: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

71165: , 0 line_number
71166: , CASE r
71167: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71168: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71169: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71170: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71171: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71172: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71173: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 71225: , AR_BILL_TO_SITE_USES_S_V h2

71221: END source_value
71222: , null source_meaning
71223: FROM xla_events_gt xet
71224: , AR_BILL_TO_CUSTOMERS_S_V h1
71225: , AR_BILL_TO_SITE_USES_S_V h2
71226: , AR_TRANSACTIONS_S_V h5
71227: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
71228: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71229: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

71510: --
71511:
71512: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
71513: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71514: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71515: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71588: , AR_BILL_TO_SITE_USES_S_V h2

71584: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
71585: , h5.TRX_DOC_SEQUENCE_ID source_82
71586: FROM xla_events_gt xet
71587: , AR_BILL_TO_CUSTOMERS_S_V h1
71588: , AR_BILL_TO_SITE_USES_S_V h2
71589: , AR_TRANSACTIONS_S_V h5
71590: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71591: and xet.event_class_code = C_EVENT_CLASS_CODE
71592: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

72646: , 0 line_number
72647: , CASE r
72648: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72649: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
72650: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
72651: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
72652: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
72653: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
72654: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 72706: , AR_BILL_TO_SITE_USES_S_V h2

72702: END source_value
72703: , null source_meaning
72704: FROM xla_events_gt xet
72705: , AR_BILL_TO_CUSTOMERS_S_V h1
72706: , AR_BILL_TO_SITE_USES_S_V h2
72707: , AR_TRANSACTIONS_S_V h5
72708: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72709: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72710: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

72986: --
72987:
72988: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72989: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72990: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72991: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73062: , AR_BILL_TO_SITE_USES_S_V h2

73058: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
73059: , h5.TRX_DOC_SEQUENCE_ID source_82
73060: FROM xla_events_gt xet
73061: , AR_BILL_TO_CUSTOMERS_S_V h1
73062: , AR_BILL_TO_SITE_USES_S_V h2
73063: , AR_TRANSACTIONS_S_V h5
73064: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73065: and xet.event_class_code = C_EVENT_CLASS_CODE
73066: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

73892: , 0 line_number
73893: , CASE r
73894: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
73895: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73896: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
73897: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73898: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73899: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
73900: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 73952: , AR_BILL_TO_SITE_USES_S_V h2

73948: END source_value
73949: , null source_meaning
73950: FROM xla_events_gt xet
73951: , AR_BILL_TO_CUSTOMERS_S_V h1
73952: , AR_BILL_TO_SITE_USES_S_V h2
73953: , AR_TRANSACTIONS_S_V h5
73954: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73956: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

74232: --
74233:
74234: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74235: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74236: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74237: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74308: , AR_BILL_TO_SITE_USES_S_V h2

74304: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
74305: , h5.TRX_DOC_SEQUENCE_ID source_82
74306: FROM xla_events_gt xet
74307: , AR_BILL_TO_CUSTOMERS_S_V h1
74308: , AR_BILL_TO_SITE_USES_S_V h2
74309: , AR_TRANSACTIONS_S_V h5
74310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74311: and xet.event_class_code = C_EVENT_CLASS_CODE
74312: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'

75140: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75141: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75142: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
75143: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75144: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
75145: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75146: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75147: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
75148: WHEN 9 THEN 'AR_TRANSACTIONS_S_V'

Line 75208: , AR_BILL_TO_SITE_USES_S_V h2

75204: END source_value
75205: , null source_meaning
75206: FROM xla_events_gt xet
75207: , AR_BILL_TO_CUSTOMERS_S_V h1
75208: , AR_BILL_TO_SITE_USES_S_V h2
75209: , AR_TRANSACTIONS_S_V h5
75210: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75211: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75212: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

75511: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
75512: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
75513: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
75514: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
75515: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
75516: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75599: , AR_BILL_TO_SITE_USES_S_V h2

75595: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
75596: , h5.TRX_DOC_SEQUENCE_ID source_82
75597: FROM xla_events_gt xet
75598: , AR_BILL_TO_CUSTOMERS_S_V h1
75599: , AR_BILL_TO_SITE_USES_S_V h2
75600: , AR_TRANSACTIONS_S_V h5
75601: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75602: and xet.event_class_code = C_EVENT_CLASS_CODE
75603: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id