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 ALL_OBJECTS

Line 66613: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

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
66615: AND xet.event_class_code = C_EVENT_CLASS_CODE
66616: AND h1.event_id = xet.event_id
66617: AND h2.event_id = h1.event_id

Line 66761: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

66757: , null source_meaning
66758: FROM xla_events_gt xet
66759: , AR_DISTRIBUTIONS_BASE_V l4
66760: , AR_DISTRIBUTIONS_L_V l5
66761: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66762: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66763: AND xet.event_class_code = C_EVENT_CLASS_CODE
66764: AND l4.event_id = xet.event_id
66765: AND l5.event_id = l4.event_id

Line 68078: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

68074: , AR_DRAWEE_CUSTOMERS_H_V h3
68075: , AR_DRAWEE_SITE_USES_H_V h4
68076: , AR_SYSTEM_PARAM_H_V h5
68077: , AR_TRANSACTIONS_S_V h6
68078: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68079: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68080: AND xet.event_class_code = C_EVENT_CLASS_CODE
68081: AND h3.event_id = xet.event_id
68082: AND h4.event_id = h3.event_id

Line 68225: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

68221: , null source_meaning
68222: FROM xla_events_gt xet
68223: , AR_DISTRIBUTIONS_BASE_V l1
68224: , AR_DISTRIBUTIONS_L_V l2
68225: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
68226: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68227: AND xet.event_class_code = C_EVENT_CLASS_CODE
68228: AND l1.event_id = xet.event_id
68229: AND l2.event_id = l1.event_id

Line 69474: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
69477: AND h1.event_id = xet.event_id
69478: AND h2.event_id = h1.event_id

Line 69615: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

69611: , null source_meaning
69612: FROM xla_events_gt xet
69613: , AR_CUST_TRX_LINES_BASE_V l3
69614: , AR_CUST_TRX_LINES_L_V l4
69615: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69616: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69617: AND xet.event_class_code = C_EVENT_CLASS_CODE
69618: AND l3.event_id = xet.event_id
69619: AND l4.event_id = l3.event_id

Line 70799: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

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
70799: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
70800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70801: AND xet.event_class_code = C_EVENT_CLASS_CODE
70802: AND h3.event_id = xet.event_id
70803: AND h1.event_id (+) = h3.event_id

Line 71021: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

71017: , fnd_lookup_values fvl13
71018: , fnd_lookup_values fvl77
71019: , fnd_lookup_values fvl78
71020: , fnd_lookup_values fvl96
71021: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
71022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71023: AND xet.event_class_code = C_EVENT_CLASS_CODE
71024: AND l5.event_id = xet.event_id
71025: AND fvl13.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'

Line 72519: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

72515: , AR_CM_BILL_SITE_USES_H_V h1
72516: , AR_CM_BILL_TO_CUST_H_V h2
72517: , AR_CREDIT_MEMO_H_V h5
72518: , AR_SYSTEM_PARAM_H_V h8
72519: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72521: AND xet.event_class_code = C_EVENT_CLASS_CODE
72522: AND h1.event_id = xet.event_id
72523: AND h2.event_id = h1.event_id

Line 72709: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

72705: , AR_CM_LINES_L_V l4
72706: , AR_DISTRIBUTIONS_L_V l6
72707: , AR_RECEIVABLES_TRX_ACT_S_V l7
72708: , AR_TRANSACTIONS_S_V l9
72709: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72710: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72711: AND xet.event_class_code = C_EVENT_CLASS_CODE
72712: AND l3.event_id = xet.event_id
72713: AND l4.event_id (+) = l3.event_id

Line 74291: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
74294: AND h1.event_id = xet.event_id
74295: AND h2.event_id = h1.event_id

Line 74437: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

74433: , null source_meaning
74434: FROM xla_events_gt xet
74435: , AR_CUST_TRX_LINES_BASE_V l3
74436: , AR_CUST_TRX_LINES_L_V l4
74437: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
74438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74439: AND xet.event_class_code = C_EVENT_CLASS_CODE
74440: AND l3.event_id = xet.event_id
74441: AND l4.event_id = l3.event_id

Line 75804: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
75807: AND h1.event_id = xet.event_id
75808: AND h2.event_id = h1.event_id

Line 75945: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

75941: , null source_meaning
75942: FROM xla_events_gt xet
75943: , AR_CUST_TRX_LINES_BASE_V l3
75944: , AR_CUST_TRX_LINES_L_V l4
75945: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75946: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75947: AND xet.event_class_code = C_EVENT_CLASS_CODE
75948: AND l3.event_id = xet.event_id
75949: AND l4.event_id = l3.event_id

Line 77129: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

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
77129: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77131: AND xet.event_class_code = C_EVENT_CLASS_CODE
77132: AND h3.event_id = xet.event_id
77133: AND h1.event_id (+) = h3.event_id

Line 77356: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)

77352: , fnd_lookup_values fvl13
77353: , fnd_lookup_values fvl77
77354: , fnd_lookup_values fvl78
77355: , fnd_lookup_values fvl96
77356: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
77357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77358: AND xet.event_class_code = C_EVENT_CLASS_CODE
77359: AND l5.event_id = xet.event_id
77360: AND fvl13.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'

Line 78903: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
78906: AND h1.event_id = xet.event_id
78907: AND h2.event_id = h1.event_id

Line 79044: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

79040: , null source_meaning
79041: FROM xla_events_gt xet
79042: , AR_CUST_TRX_LINES_BASE_V l3
79043: , AR_CUST_TRX_LINES_L_V l4
79044: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
79045: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79046: AND xet.event_class_code = C_EVENT_CLASS_CODE
79047: AND l3.event_id = xet.event_id
79048: AND l4.event_id = l3.event_id

Line 80181: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
80184: AND h1.event_id = xet.event_id
80185: AND h2.event_id = h1.event_id

Line 80332: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

80328: , null source_meaning
80329: FROM xla_events_gt xet
80330: , AR_CUST_TRX_LINES_BASE_V l3
80331: , AR_CUST_TRX_LINES_L_V l4
80332: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
80333: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80334: AND xet.event_class_code = C_EVENT_CLASS_CODE
80335: AND l3.event_id = xet.event_id
80336: AND l4.event_id = l3.event_id

Line 81805: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

81801: FROM xla_events_gt xet
81802: , AR_CASH_RECEIPTS_H_V h1
81803: , AR_RCT_METHOD_H_V h4
81804: , AR_REMIT_BANK_ACCT_H_V h5
81805: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
81806: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81807: AND xet.event_class_code = C_EVENT_CLASS_CODE
81808:
81809: )

Line 81953: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

81949: , null source_meaning
81950: FROM xla_events_gt xet
81951: , AR_DISTRIBUTIONS_BASE_V l2
81952: , AR_DISTRIBUTIONS_L_V l3
81953: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
81954: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81955: AND xet.event_class_code = C_EVENT_CLASS_CODE
81956: AND l2.event_id = xet.event_id
81957: AND l3.event_id = l2.event_id

Line 83324: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83323: , AR_SYSTEM_PARAM_H_V h9
83324: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
83325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83326: AND xet.event_class_code = C_EVENT_CLASS_CODE
83327: AND h1.event_id = xet.event_id
83328: AND h5.event_id (+) = h1.event_id

Line 83575: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)

83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83574: , AR_TRANSACTIONS_S_V l10
83575: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
83576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83577: AND xet.event_class_code = C_EVENT_CLASS_CODE
83578: AND l3.event_id = xet.event_id
83579: AND l2.event_id (+) = l3.event_id