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 ALL_OBJECTS

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

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
63113: AND xet.event_class_code = C_EVENT_CLASS_CODE
63114: AND h1.event_id = xet.event_id
63115: AND h2.event_id = h1.event_id

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

63255: , null source_meaning
63256: FROM xla_events_gt xet
63257: , AR_DISTRIBUTIONS_BASE_V l4
63258: , AR_DISTRIBUTIONS_L_V l5
63259: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
63260: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63261: AND xet.event_class_code = C_EVENT_CLASS_CODE
63262: AND l4.event_id = xet.event_id
63263: AND l5.event_id = l4.event_id

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

64547: , AR_DRAWEE_CUSTOMERS_H_V h3
64548: , AR_DRAWEE_SITE_USES_H_V h4
64549: , AR_SYSTEM_PARAM_H_V h5
64550: , AR_TRANSACTIONS_S_V h6
64551: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
64552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64553: AND xet.event_class_code = C_EVENT_CLASS_CODE
64554: AND h3.event_id = xet.event_id
64555: AND h4.event_id = h3.event_id

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

64694: , null source_meaning
64695: FROM xla_events_gt xet
64696: , AR_DISTRIBUTIONS_BASE_V l1
64697: , AR_DISTRIBUTIONS_L_V l2
64698: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
64699: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64700: AND xet.event_class_code = C_EVENT_CLASS_CODE
64701: AND l1.event_id = xet.event_id
64702: AND l2.event_id = l1.event_id

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

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

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

66054: , null source_meaning
66055: FROM xla_events_gt xet
66056: , AR_CUST_TRX_LINES_BASE_V l3
66057: , AR_CUST_TRX_LINES_L_V l4
66058: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
66059: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66060: AND xet.event_class_code = C_EVENT_CLASS_CODE
66061: AND l3.event_id = xet.event_id
66062: AND l4.event_id = l3.event_id

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

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)
67190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67191: AND xet.event_class_code = C_EVENT_CLASS_CODE
67192: AND h5.event_id = xet.event_id
67193: AND h1.event_id (+) = h5.event_id

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

67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67409: , fnd_lookup_values fvl85
67410: , (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
67411: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67412: AND xet.event_class_code = C_EVENT_CLASS_CODE
67413: AND l4.event_id = xet.event_id
67414: AND fvl7.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'

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

68840: , AR_CM_BILL_SITE_USES_H_V h1
68841: , AR_CM_BILL_TO_CUST_H_V h2
68842: , AR_CREDIT_MEMO_H_V h5
68843: , AR_SYSTEM_PARAM_H_V h9
68844: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
68845: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68846: AND xet.event_class_code = C_EVENT_CLASS_CODE
68847: AND h1.event_id = xet.event_id
68848: AND h2.event_id = h1.event_id

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

69036: , AR_CUST_TRX_LINES_L_V l6
69037: , AR_DISTRIBUTIONS_L_V l7
69038: , AR_RECEIVABLES_TRX_ACT_S_V l8
69039: , AR_TRANSACTIONS_S_V l10
69040: , (select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
69041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69042: AND xet.event_class_code = C_EVENT_CLASS_CODE
69043: AND l3.event_id = xet.event_id
69044: AND l4.event_id (+) = l3.event_id

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

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

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

70711: , null source_meaning
70712: FROM xla_events_gt xet
70713: , AR_CUST_TRX_LINES_BASE_V l3
70714: , AR_CUST_TRX_LINES_L_V l4
70715: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
70716: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70717: AND xet.event_class_code = C_EVENT_CLASS_CODE
70718: AND l3.event_id = xet.event_id
70719: AND l4.event_id = l3.event_id

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

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

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

72161: , null source_meaning
72162: FROM xla_events_gt xet
72163: , AR_CUST_TRX_LINES_BASE_V l3
72164: , AR_CUST_TRX_LINES_L_V l4
72165: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72166: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72167: AND xet.event_class_code = C_EVENT_CLASS_CODE
72168: AND l3.event_id = xet.event_id
72169: AND l4.event_id = l3.event_id

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

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)
73297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73298: AND xet.event_class_code = C_EVENT_CLASS_CODE
73299: AND h5.event_id = xet.event_id
73300: AND h1.event_id (+) = h5.event_id

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

73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73521: , fnd_lookup_values fvl85
73522: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73523: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73524: AND xet.event_class_code = C_EVENT_CLASS_CODE
73525: AND l4.event_id = xet.event_id
73526: AND fvl7.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'

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

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

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

75147: , null source_meaning
75148: FROM xla_events_gt xet
75149: , AR_CUST_TRX_LINES_BASE_V l3
75150: , AR_CUST_TRX_LINES_L_V l4
75151: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75153: AND xet.event_class_code = C_EVENT_CLASS_CODE
75154: AND l3.event_id = xet.event_id
75155: AND l4.event_id = l3.event_id

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

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

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

76408: , null source_meaning
76409: FROM xla_events_gt xet
76410: , AR_CUST_TRX_LINES_BASE_V l3
76411: , AR_CUST_TRX_LINES_L_V l4
76412: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
76413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76414: AND xet.event_class_code = C_EVENT_CLASS_CODE
76415: AND l3.event_id = xet.event_id
76416: AND l4.event_id = l3.event_id

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

77843: , AR_CASH_RECEIPTS_H_V h1
77844: , AR_RCT_METHOD_H_V h4
77845: , AR_RECEIVABLES_TRX_MISC_H_V h5
77846: , AR_REMIT_BANK_ACCT_H_V h6
77847: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
77848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77849: AND xet.event_class_code = C_EVENT_CLASS_CODE
77850: AND h5.event_id = xet.event_id
77851: AND h1.event_id (+) = h5.event_id

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

77995: , null source_meaning
77996: FROM xla_events_gt xet
77997: , AR_DISTRIBUTIONS_BASE_V l2
77998: , AR_DISTRIBUTIONS_L_V l3
77999: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
78000: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78001: AND xet.event_class_code = C_EVENT_CLASS_CODE
78002: AND l2.event_id = xet.event_id
78003: AND l3.event_id = l2.event_id

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

79377: , AR_RCT_METHOD_H_V h5
79378: , AR_RCT_SITE_USES_H_V h6
79379: , AR_REMIT_BANK_ACCT_H_V h8
79380: , AR_SYSTEM_PARAM_H_V h9
79381: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
79382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79383: AND xet.event_class_code = C_EVENT_CLASS_CODE
79384: AND h1.event_id = xet.event_id
79385: AND h5.event_id (+) = h1.event_id

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

79628: , AR_DISTRIBUTIONS_BASE_V l3
79629: , AR_DISTRIBUTIONS_L_V l4
79630: , AR_RECEIVABLES_TRX_ACT_S_V l7
79631: , AR_TRANSACTIONS_S_V l10
79632: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
79633: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79634: AND xet.event_class_code = C_EVENT_CLASS_CODE
79635: AND l3.event_id = xet.event_id
79636: AND l2.event_id (+) = l3.event_id