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

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

182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86
182682: , fnd_lookup_values fvl159
182683: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
182684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182685: AND xet.event_class_code = C_EVENT_CLASS_CODE
182686: AND h2.event_id = xet.event_id
182687: AND h4.asp_org_id = h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

183076: , fnd_lookup_values fvl68
183077: , fnd_lookup_values fvl84
183078: , fnd_lookup_values fvl87
183079: , fnd_lookup_values fvl135
183080: , (select rownum r from all_objects where rownum <= 54 and owner = p_apps_owner)
183081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183082: AND xet.event_class_code = C_EVENT_CLASS_CODE
183083: AND l1.event_id = xet.event_id
183084: 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 fvl10.lookup_type(+) = 'DESTINATION TYPE'

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

186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35
186905: , fnd_lookup_values fvl86
186906: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
186907: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186908: AND xet.event_class_code = C_EVENT_CLASS_CODE
186909: AND h2.event_id = xet.event_id
186910: AND h4.asp_org_id= h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

187290: , fnd_lookup_values fvl68
187291: , fnd_lookup_values fvl84
187292: , fnd_lookup_values fvl87
187293: , fnd_lookup_values fvl135
187294: , (select rownum r from all_objects where rownum <= 53 and owner = p_apps_owner)
187295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187296: AND xet.event_class_code = C_EVENT_CLASS_CODE
187297: AND l1.event_id = xet.event_id
187298: 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 fvl10.lookup_type(+) = 'DESTINATION TYPE'

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

191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35
191081: , fnd_lookup_values fvl105
191082: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
191083: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191084: AND xet.event_class_code = C_EVENT_CLASS_CODE
191085: AND h2.event_id = xet.event_id
191086: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

191320: , fnd_lookup_values fvl21
191321: , fnd_lookup_values fvl68
191322: , fnd_lookup_values fvl90
191323: , fnd_lookup_values fvl130
191324: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
191325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191326: AND xet.event_class_code = C_EVENT_CLASS_CODE
191327: AND l1.event_id = xet.event_id
191328: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl21.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86
193388: , fnd_lookup_values fvl159
193389: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
193390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193391: AND xet.event_class_code = C_EVENT_CLASS_CODE
193392: AND h2.event_id = xet.event_id
193393: AND h4.asp_org_id = h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

193792: , fnd_lookup_values fvl68
193793: , fnd_lookup_values fvl84
193794: , fnd_lookup_values fvl87
193795: , fnd_lookup_values fvl135
193796: , (select rownum r from all_objects where rownum <= 56 and owner = p_apps_owner)
193797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193798: AND xet.event_class_code = C_EVENT_CLASS_CODE
193799: AND l1.event_id = xet.event_id
193800: 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 fvl10.lookup_type(+) = 'DESTINATION TYPE'

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

197693: END source_value
197694: , null source_meaning
197695: FROM xla_events_gt xet
197696: , PA_XLA_BC_PKT_AP_DETAIL_V l1
197697: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
197698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197699: AND xet.event_class_code = C_EVENT_CLASS_CODE
197700: AND l1.event_id = xet.event_id
197701:

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

198912: , fnd_lookup_values fvl35
198913: , fnd_lookup_values fvl105
198914: , fnd_lookup_values fvl115
198915: , fnd_lookup_values fvl185
198916: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
198917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198918: AND xet.event_class_code = C_EVENT_CLASS_CODE
198919: AND h2.event_id = xet.event_id
198920: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

199220: , fnd_lookup_values fvl90
199221: , fnd_lookup_values fvl130
199222: , fnd_lookup_values fvl158
199223: , fnd_lookup_values fvl160
199224: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
199225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199226: AND xet.event_class_code = C_EVENT_CLASS_CODE
199227: AND l1.event_id = xet.event_id
199228: 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 fvl21.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

201916: , AP_INVOICE_EXTRACT_HEADER_V h1
201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
201918: , fnd_lookup_values fvl3
201919: , fnd_lookup_values fvl86
201920: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
201921: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201922: AND xet.event_class_code = C_EVENT_CLASS_CODE
201923: AND h1.event_id = xet.event_id
201924: AND h4.asp_org_id = h1.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

202276: , fnd_lookup_values fvl68
202277: , fnd_lookup_values fvl87
202278: , fnd_lookup_values fvl119
202279: , fnd_lookup_values fvl130
202280: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
202281: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
202282: AND xet.event_class_code = C_EVENT_CLASS_CODE
202283: AND l2.event_id = xet.event_id
202284: 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 fvl68.lookup_type(+) = 'YES_NO'

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

204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35
204405: , fnd_lookup_values fvl86
204406: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
204407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204408: AND xet.event_class_code = C_EVENT_CLASS_CODE
204409: AND h2.event_id = xet.event_id
204410: AND h4.asp_org_id = h2.ai_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

204786: , fnd_lookup_values fvl84
204787: , fnd_lookup_values fvl87
204788: , fnd_lookup_values fvl130
204789: , fnd_lookup_values fvl135
204790: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
204791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204792: AND xet.event_class_code = C_EVENT_CLASS_CODE
204793: AND l1.event_id = xet.event_id
204794: 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 fvl10.lookup_type(+) = 'DESTINATION TYPE'

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

208597: END source_value
208598: , null source_meaning
208599: FROM xla_events_gt xet
208600: , PA_XLA_BC_PKT_AP_DETAIL_V l1
208601: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
208602: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
208603: AND xet.event_class_code = C_EVENT_CLASS_CODE
208604: AND l1.event_id = xet.event_id
208605:

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

209709: END source_value
209710: , null source_meaning
209711: FROM xla_events_gt xet
209712: , PA_XLA_BC_PKT_AP_DETAIL_V l1
209713: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
209714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
209715: AND xet.event_class_code = C_EVENT_CLASS_CODE
209716: AND l1.event_id = xet.event_id
209717:

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

210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105
210917: , fnd_lookup_values fvl115
210918: ,(select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
210919: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
210920: AND xet.event_class_code = C_EVENT_CLASS_CODE
210921: AND h2.event_id = xet.event_id
210922: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

211253: , fnd_lookup_values fvl90
211254: , fnd_lookup_values fvl130
211255: , fnd_lookup_values fvl158
211256: , fnd_lookup_values fvl160
211257: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
211258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
211259: AND xet.event_class_code = C_EVENT_CLASS_CODE
211260: AND l1.event_id = xet.event_id
211261: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl21.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105
213978: , fnd_lookup_values fvl115
213979: , fnd_lookup_values fvl185
213980: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
213981: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
213982: AND xet.event_class_code = C_EVENT_CLASS_CODE
213983: AND h2.event_id = xet.event_id
213984: AND h3.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

214239: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214240: , fnd_lookup_values fvl21
214241: , fnd_lookup_values fvl68
214242: , fnd_lookup_values fvl90
214243: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
214244: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
214245: AND xet.event_class_code = C_EVENT_CLASS_CODE
214246: AND l1.event_id = xet.event_id
214247: 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 fvl21.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'