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

Line 67702: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'

67698: , CASE r
67699: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
67700: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
67701: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67702: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
67703: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
67704: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
67705: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
67706: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'

Line 67763: , AR_BILL_TO_SITE_USES_S_V h3

67759: , null source_meaning
67760: FROM xla_events_gt xet
67761: , AR_ADJUSTMENTS_H_V h1
67762: , AR_BILL_TO_CUSTOMERS_S_V h2
67763: , AR_BILL_TO_SITE_USES_S_V h3
67764: , AR_RECEIVABLES_TRX_ACT_S_V h6
67765: , AR_TRANSACTIONS_S_V h7
67766: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
67767: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 68056: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

68052:
68053: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
68054: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
68055: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68056: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68057: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68058: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68059: TYPE t_array_source_82 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68060: TYPE t_array_source_83 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 68133: , AR_BILL_TO_SITE_USES_S_V h3

68129: , h1.ADJ_DOC_SEQUENCE_VALUE source_83
68130: FROM xla_events_gt xet
68131: , AR_ADJUSTMENTS_H_V h1
68132: , AR_BILL_TO_CUSTOMERS_S_V h2
68133: , AR_BILL_TO_SITE_USES_S_V h3
68134: , AR_RECEIVABLES_TRX_ACT_S_V h6
68135: , AR_TRANSACTIONS_S_V h7
68136: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68137: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'

69066: SELECT xet.event_id event_id
69067: , 0 line_number
69068: , CASE r
69069: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
69070: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
69071: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69072: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
69073: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
69074: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 69127: , AR_BILL_TO_SITE_USES_S_V h2

69123: END source_value
69124: , null source_meaning
69125: FROM xla_events_gt xet
69126: , AR_BILL_TO_CUSTOMERS_S_V h1
69127: , AR_BILL_TO_SITE_USES_S_V h2
69128: , AR_TRANSACTIONS_S_V h5
69129: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
69130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69131: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

69406: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69407: --
69408:
69409: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69410: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69411: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69412: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69483: , AR_BILL_TO_SITE_USES_S_V h2

69479: , h5.TRX_DOC_SEQUENCE_ID source_86
69480: , h5.TRX_DOC_SEQUENCE_VALUE source_87
69481: FROM xla_events_gt xet
69482: , AR_BILL_TO_CUSTOMERS_S_V h1
69483: , AR_BILL_TO_SITE_USES_S_V h2
69484: , AR_TRANSACTIONS_S_V h5
69485: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69486: and xet.event_class_code = C_EVENT_CLASS_CODE
69487: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

71932: , 0 line_number
71933: , CASE r
71934: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
71935: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
71936: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
71937: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
71938: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
71939: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
71940: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 72002: , AR_BILL_TO_SITE_USES_S_V h2

71998: END source_value
71999: , null source_meaning
72000: FROM xla_events_gt xet
72001: , AR_BILL_TO_CUSTOMERS_S_V h1
72002: , AR_BILL_TO_SITE_USES_S_V h2
72003: , AR_TRANSACTIONS_S_V h5
72004: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72005: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72006: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

72287: --
72288:
72289: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
72290: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72291: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72292: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72293: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72294: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 72371: , AR_BILL_TO_SITE_USES_S_V h2

72367: , h5.TRX_DOC_SEQUENCE_ID source_86
72368: , h5.TRX_DOC_SEQUENCE_VALUE source_87
72369: FROM xla_events_gt xet
72370: , AR_BILL_TO_CUSTOMERS_S_V h1
72371: , AR_BILL_TO_SITE_USES_S_V h2
72372: , AR_TRANSACTIONS_S_V h5
72373: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72374: and xet.event_class_code = C_EVENT_CLASS_CODE
72375: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'

73402: SELECT xet.event_id event_id
73403: , 0 line_number
73404: , CASE r
73405: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
73406: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
73407: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
73408: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
73409: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
73410: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 73463: , AR_BILL_TO_SITE_USES_S_V h2

73459: END source_value
73460: , null source_meaning
73461: FROM xla_events_gt xet
73462: , AR_BILL_TO_CUSTOMERS_S_V h1
73463: , AR_BILL_TO_SITE_USES_S_V h2
73464: , AR_TRANSACTIONS_S_V h5
73465: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73466: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73467: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

73742: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73743: --
73744:
73745: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
73746: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
73747: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
73748: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73819: , AR_BILL_TO_SITE_USES_S_V h2

73815: , h5.TRX_DOC_SEQUENCE_ID source_86
73816: , h5.TRX_DOC_SEQUENCE_VALUE source_87
73817: FROM xla_events_gt xet
73818: , AR_BILL_TO_CUSTOMERS_S_V h1
73819: , AR_BILL_TO_SITE_USES_S_V h2
73820: , AR_TRANSACTIONS_S_V h5
73821: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73822: and xet.event_class_code = C_EVENT_CLASS_CODE
73823: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'

74648: SELECT xet.event_id event_id
74649: , 0 line_number
74650: , CASE r
74651: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
74652: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
74653: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
74654: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
74655: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
74656: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 74709: , AR_BILL_TO_SITE_USES_S_V h2

74705: END source_value
74706: , null source_meaning
74707: FROM xla_events_gt xet
74708: , AR_BILL_TO_CUSTOMERS_S_V h1
74709: , AR_BILL_TO_SITE_USES_S_V h2
74710: , AR_TRANSACTIONS_S_V h5
74711: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74713: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

74988: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74989: --
74990:
74991: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
74993: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74994: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75065: , AR_BILL_TO_SITE_USES_S_V h2

75061: , h5.TRX_DOC_SEQUENCE_ID source_86
75062: , h5.TRX_DOC_SEQUENCE_VALUE source_87
75063: FROM xla_events_gt xet
75064: , AR_BILL_TO_CUSTOMERS_S_V h1
75065: , AR_BILL_TO_SITE_USES_S_V h2
75066: , AR_TRANSACTIONS_S_V h5
75067: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75068: and xet.event_class_code = C_EVENT_CLASS_CODE
75069: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'

75896: , CASE r
75897: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
75898: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75899: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
75900: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
75901: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
75902: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
75903: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
75904: WHEN 8 THEN 'AR_TRANSACTIONS_S_V'

Line 75970: , AR_BILL_TO_SITE_USES_S_V h2

75966: END source_value
75967: , null source_meaning
75968: FROM xla_events_gt xet
75969: , AR_BILL_TO_CUSTOMERS_S_V h1
75970: , AR_BILL_TO_SITE_USES_S_V h2
75971: , AR_TRANSACTIONS_S_V h5
75972: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
75973: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75974: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

76272:
76273: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
76274: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
76275: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
76276: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_70 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 76364: , AR_BILL_TO_SITE_USES_S_V h2

76360: , h5.TRX_DOC_SEQUENCE_ID source_86
76361: , h5.TRX_DOC_SEQUENCE_VALUE source_87
76362: FROM xla_events_gt xet
76363: , AR_BILL_TO_CUSTOMERS_S_V h1
76364: , AR_BILL_TO_SITE_USES_S_V h2
76365: , AR_TRANSACTIONS_S_V h5
76366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76367: and xet.event_class_code = C_EVENT_CLASS_CODE
76368: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id