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

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

65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65350: , fnd_lookup_values fvl17
65351: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
65352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65353: AND xet.event_class_code = C_EVENT_CLASS_CODE
65354: AND h2.event_id = xet.event_id
65355: AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46
65705: , fnd_lookup_values fvl59
65706: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
65707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65708: AND xet.event_class_code = C_EVENT_CLASS_CODE
65709: AND l1.event_id = xet.event_id
65710: 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 fvl9.lookup_type(+) = 'DESTINATION TYPE'

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

68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68208: , fnd_lookup_values fvl17
68209: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
68210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68211: AND xet.event_class_code = C_EVENT_CLASS_CODE
68212: AND h2.event_id = xet.event_id
68213: AND h3.asp_org_id= h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46
68558: , fnd_lookup_values fvl59
68559: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
68560: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68561: AND xet.event_class_code = C_EVENT_CLASS_CODE
68562: AND l1.event_id = xet.event_id
68563: 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 fvl9.lookup_type(+) = 'DESTINATION TYPE'

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

71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71046: , fnd_lookup_values fvl17
71047: , fnd_lookup_values fvl68
71048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
71049: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71050: AND xet.event_class_code = C_EVENT_CLASS_CODE
71051: AND h2.event_id = xet.event_id
71052: AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46
71411: , fnd_lookup_values fvl59
71412: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
71413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71414: AND xet.event_class_code = C_EVENT_CLASS_CODE
71415: AND l1.event_id = xet.event_id
71416: 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 fvl9.lookup_type(+) = 'DESTINATION TYPE'

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

74185: , PA_XLA_EXP_ORG_REF_V l2
74186: , PA_XLA_PROJECT_REF_V l3
74187: , PA_XLA_TASK_REF_V l4
74188: , fnd_lookup_values fvl108
74189: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
74190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74191: AND xet.event_class_code = C_EVENT_CLASS_CODE
74192: AND l1.event_id = xet.event_id
74193: AND l2.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'

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

75833: FROM xla_events_gt xet
75834: , AP_INVOICE_EXTRACT_HEADER_V h1
75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
75836: , fnd_lookup_values fvl17
75837: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75839: AND xet.event_class_code = C_EVENT_CLASS_CODE
75840: AND h1.event_id = xet.event_id
75841: AND h3.asp_org_id = h1.ai_org_id AND fvl17.lookup_type(+) = 'YES_NO'

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

76112: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76113: , ZX_AP_DEF_TAX_EXTRACT_V l4
76114: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76115: , fnd_lookup_values fvl46
76116: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
76117: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76118: AND xet.event_class_code = C_EVENT_CLASS_CODE
76119: AND l2.event_id = xet.event_id
76120: AND l2.recp_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l2.recp_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl46.lookup_type(+) = 'YES_NO'

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

77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77480: , fnd_lookup_values fvl17
77481: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
77482: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77483: AND xet.event_class_code = C_EVENT_CLASS_CODE
77484: AND h2.event_id = xet.event_id
77485: AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46
77835: , fnd_lookup_values fvl59
77836: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
77837: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77838: AND xet.event_class_code = C_EVENT_CLASS_CODE
77839: AND l1.event_id = xet.event_id
77840: 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 fvl9.lookup_type(+) = 'DESTINATION TYPE'

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

80485: , PA_XLA_EXP_ORG_REF_V l2
80486: , PA_XLA_PROJECT_REF_V l3
80487: , PA_XLA_TASK_REF_V l4
80488: , fnd_lookup_values fvl108
80489: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
80490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80491: AND xet.event_class_code = C_EVENT_CLASS_CODE
80492: AND l1.event_id = xet.event_id
80493: AND l2.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'

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

82135: , PA_XLA_EXP_ORG_REF_V l2
82136: , PA_XLA_PROJECT_REF_V l3
82137: , PA_XLA_TASK_REF_V l4
82138: , fnd_lookup_values fvl108
82139: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
82140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82141: AND xet.event_class_code = C_EVENT_CLASS_CODE
82142: AND l1.event_id = xet.event_id
82143: AND l2.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'