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

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

36508: END source_meaning
36509: FROM xla_events_gt xet
36510: , AP_INVOICE_EXTRACT_HEADER_V h2
36511: , fnd_lookup_values fvl13
36512: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
36513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36514: AND xet.event_class_code = C_EVENT_CLASS_CODE
36515: AND h2.event_id = xet.event_id
36516: AND fvl13.lookup_type(+) = 'INVOICE TYPE'

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

36837: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
36838: , fnd_lookup_values fvl8
36839: , fnd_lookup_values fvl11
36840: , fnd_lookup_values fvl42
36841: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
36842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36843: AND xet.event_class_code = C_EVENT_CLASS_CODE
36844: AND l1.event_id = xet.event_id
36845: AND l3.federal_event_id (+) = l1.event_id and l3.federal_line_number (+) = l1.line_number AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl8.lookup_type(+) =

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

38853: END source_meaning
38854: FROM xla_events_gt xet
38855: , AP_INVOICE_EXTRACT_HEADER_V h2
38856: , fnd_lookup_values fvl13
38857: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
38858: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
38859: AND xet.event_class_code = C_EVENT_CLASS_CODE
38860: AND h2.event_id = xet.event_id
38861: AND fvl13.lookup_type(+) = 'INVOICE TYPE'

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

39182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39183: , fnd_lookup_values fvl8
39184: , fnd_lookup_values fvl11
39185: , fnd_lookup_values fvl42
39186: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
39187: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
39188: AND xet.event_class_code = C_EVENT_CLASS_CODE
39189: AND l1.event_id = xet.event_id
39190: AND l3.federal_event_id (+) = l1.event_id and l3.federal_line_number (+) = l1.line_number AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl8.lookup_type(+) =

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

41194: , AP_INVOICE_EXTRACT_HEADER_V h2
41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41196: , fnd_lookup_values fvl13
41197: , fnd_lookup_values fvl60
41198: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
41199: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
41200: AND xet.event_class_code = C_EVENT_CLASS_CODE
41201: AND h2.event_id = xet.event_id
41202: AND h3.asp_org_id = h2.ai_org_id AND fvl13.lookup_type(+) = 'INVOICE TYPE'

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

41582: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
41583: , fnd_lookup_values fvl8
41584: , fnd_lookup_values fvl11
41585: , fnd_lookup_values fvl42
41586: , (select rownum r from all_objects where rownum <= 55 and owner = p_apps_owner)
41587: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
41588: AND xet.event_class_code = C_EVENT_CLASS_CODE
41589: AND l1.event_id = xet.event_id
41590: AND l4.federal_event_id (+) = l1.event_id and l4.federal_line_number (+) = l1.line_number 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 fvl8.lookup_type(+) =

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

44216: END source_meaning
44217: FROM xla_events_gt xet
44218: , AP_INVOICE_EXTRACT_HEADER_V h2
44219: , fnd_lookup_values fvl13
44220: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
44221: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
44222: AND xet.event_class_code = C_EVENT_CLASS_CODE
44223: AND h2.event_id = xet.event_id
44224: AND fvl13.lookup_type(+) = 'INVOICE TYPE'

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

44496: , FV_XLA_AP_REF_V l3
44497: , ZX_AP_DEF_TAX_EXTRACT_V l4
44498: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44499: , fnd_lookup_values fvl42
44500: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
44501: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
44502: AND xet.event_class_code = C_EVENT_CLASS_CODE
44503: AND l1.event_id = xet.event_id
44504: AND l3.federal_event_id (+) = l1.event_id and l3.federal_line_number (+) = l1.line_number AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl42.lookup_type(+) = 'YES_NO'