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_00200_AAD_S_000012_PKG dependencies on ALL_OBJECTS

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

152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
152706: , fnd_lookup_values fvl167
152707: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
152708: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152709: AND xet.event_class_code = C_EVENT_CLASS_CODE
152710: AND h2.event_id = xet.event_id
152711: AND h4.asp_org_id = h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

153059: , fnd_lookup_values fvl28
153060: , fnd_lookup_values fvl54
153061: , fnd_lookup_values fvl85
153062: , fnd_lookup_values fvl145
153063: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
153064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153065: AND xet.event_class_code = C_EVENT_CLASS_CODE
153066: AND l1.event_id = xet.event_id
153067: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl17.lookup_type(+) = 'DESTINATION TYPE'

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

155950: , AP_INVOICE_EXTRACT_HEADER_V h2
155951: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
155952: , fnd_lookup_values fvl10
155953: , fnd_lookup_values fvl43
155954: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155956: AND xet.event_class_code = C_EVENT_CLASS_CODE
155957: AND h2.event_id = xet.event_id
155958: AND h4.asp_org_id= h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

156297: , fnd_lookup_values fvl28
156298: , fnd_lookup_values fvl54
156299: , fnd_lookup_values fvl85
156300: , fnd_lookup_values fvl145
156301: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
156302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156303: AND xet.event_class_code = C_EVENT_CLASS_CODE
156304: AND l1.event_id = xet.event_id
156305: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl17.lookup_type(+) = 'DESTINATION TYPE'

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

159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159175: , fnd_lookup_values fvl116
159176: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
159177: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159178: AND xet.event_class_code = C_EVENT_CLASS_CODE
159179: AND h2.event_id = xet.event_id
159180: AND h3.asp_org_id = h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159416: , fnd_lookup_values fvl101
159417: , fnd_lookup_values fvl140
159418: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
159419: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159420: AND xet.event_class_code = C_EVENT_CLASS_CODE
159421: AND l1.event_id = xet.event_id
159422: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl28.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161475: , fnd_lookup_values fvl167
161476: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
161477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161478: AND xet.event_class_code = C_EVENT_CLASS_CODE
161479: AND h2.event_id = xet.event_id
161480: AND h4.asp_org_id = h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

161838: , fnd_lookup_values fvl28
161839: , fnd_lookup_values fvl54
161840: , fnd_lookup_values fvl85
161841: , fnd_lookup_values fvl145
161842: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
161843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161844: AND xet.event_class_code = C_EVENT_CLASS_CODE
161845: AND l1.event_id = xet.event_id
161846: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl17.lookup_type(+) = 'DESTINATION TYPE'

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

164932: , fnd_lookup_values fvl43
164933: , fnd_lookup_values fvl116
164934: , fnd_lookup_values fvl125
164935: , fnd_lookup_values fvl177
164936: ,(select rownum r from all_objects where rownum <= 41 and owner = p_apps_owner)
164937: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164938: AND xet.event_class_code = C_EVENT_CLASS_CODE
164939: AND h2.event_id = xet.event_id
164940: AND h3.asp_org_id = h2.ac_org_id AND h5.federal_org_id=h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

165283: , fnd_lookup_values fvl85
165284: , fnd_lookup_values fvl101
165285: , fnd_lookup_values fvl140
165286: , fnd_lookup_values fvl166
165287: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165289: AND xet.event_class_code = C_EVENT_CLASS_CODE
165290: AND l1.event_id = xet.event_id
165291: AND l4.federal_event_id (+) = l1.event_id and l4.federal_line_number (+) = l1.line_number AND l1.aid_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l7.rec_nrec_tax_dist_id (+) AND fvl28.lookup_type(+) =

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

168588: FROM xla_events_gt xet
168589: , AP_INVOICE_EXTRACT_HEADER_V h1
168590: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
168591: , fnd_lookup_values fvl10
168592: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
168593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168594: AND xet.event_class_code = C_EVENT_CLASS_CODE
168595: AND h1.event_id = xet.event_id
168596: AND h4.asp_org_id = h1.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
168938: , fnd_lookup_values fvl85
168939: , fnd_lookup_values fvl129
168940: , fnd_lookup_values fvl140
168941: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
168942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168943: AND xet.event_class_code = C_EVENT_CLASS_CODE
168944: AND l2.event_id = xet.event_id
168945: AND l2.pp_detail_tax_dist_id = l3.rec_nrec_pp_tax_dist_id (+) AND l2.recp_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l2.recp_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl85.lookup_type(+) = 'YES_NO'

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

170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
170967: , fnd_lookup_values fvl43
170968: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
170969: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170970: AND xet.event_class_code = C_EVENT_CLASS_CODE
170971: AND h2.event_id = xet.event_id
170972: AND h4.asp_org_id = h2.ai_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

171307: , fnd_lookup_values fvl54
171308: , fnd_lookup_values fvl85
171309: , fnd_lookup_values fvl140
171310: , fnd_lookup_values fvl145
171311: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
171312: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171313: AND xet.event_class_code = C_EVENT_CLASS_CODE
171314: AND l1.event_id = xet.event_id
171315: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl17.lookup_type(+) = 'DESTINATION TYPE'

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

174275: , fnd_lookup_values fvl14
174276: , fnd_lookup_values fvl43
174277: , fnd_lookup_values fvl116
174278: , fnd_lookup_values fvl125
174279: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
174280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174281: AND xet.event_class_code = C_EVENT_CLASS_CODE
174282: AND h2.event_id = xet.event_id
174283: AND h3.asp_org_id = h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

174614: , fnd_lookup_values fvl85
174615: , fnd_lookup_values fvl101
174616: , fnd_lookup_values fvl140
174617: , fnd_lookup_values fvl166
174618: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
174619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174620: AND xet.event_class_code = C_EVENT_CLASS_CODE
174621: AND l1.event_id = xet.event_id
174622: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl28.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

177337: , fnd_lookup_values fvl43
177338: , fnd_lookup_values fvl116
177339: , fnd_lookup_values fvl125
177340: , fnd_lookup_values fvl177
177341: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177342: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177343: AND xet.event_class_code = C_EVENT_CLASS_CODE
177344: AND h2.event_id = xet.event_id
177345: AND h3.asp_org_id = h2.ac_org_id AND fvl10.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
177601: , fnd_lookup_values fvl28
177602: , fnd_lookup_values fvl85
177603: , fnd_lookup_values fvl101
177604: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
177605: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177606: AND xet.event_class_code = C_EVENT_CLASS_CODE
177607: AND l1.event_id = xet.event_id
177608: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl28.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'