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

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

48499: END source_value
48500: , null source_meaning
48501: FROM xla_events_gt xet
48502: , PA_XLA_BC_PKT_PO_HEADER_V h2
48503: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
48504: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
48505: AND xet.event_class_code = C_EVENT_CLASS_CODE
48506: AND h2.event_id = xet.event_id
48507:

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

48835: , PA_XLA_BC_PKT_PO_DETAIL_V l1
48836: , PA_XLA_PROJECT_REF_V l3
48837: , PA_XLA_TASK_REF_V l4
48838: , fnd_lookup_values fvl14
48839: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
48840: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
48841: AND xet.event_class_code = C_EVENT_CLASS_CODE
48842: AND l1.event_id = xet.event_id
48843: AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'

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

51011: END source_value
51012: , null source_meaning
51013: FROM xla_events_gt xet
51014: , PO_EXTRACT_HEADER_V h3
51015: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
51016: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
51017: AND xet.event_class_code = C_EVENT_CLASS_CODE
51018: AND h3.event_id = xet.event_id
51019:

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

51230: , null source_meaning
51231: FROM xla_events_gt xet
51232: , PO_DISTS_REF_V l1
51233: , PO_EXTRACT_DETAIL_V l2
51234: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
51235: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
51236: AND xet.event_class_code = C_EVENT_CLASS_CODE
51237: AND l2.event_id = xet.event_id
51238: AND l2.po_distribution_id = l1.po_distribution_id (+) and l2.po_distribution_type = l1.po_distribution_type (+)

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

52810: , null source_meaning
52811: FROM xla_events_gt xet
52812: , PO_EXTRACT_HEADER_V h3
52813: , PO_RELEASES_REF_V h4
52814: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
52815: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52816: AND xet.event_class_code = C_EVENT_CLASS_CODE
52817: AND h3.event_id = xet.event_id
52818: AND h3.po_release_id = h4.po_release_id

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

53019: , null source_meaning
53020: FROM xla_events_gt xet
53021: , PO_DISTS_REF_V l1
53022: , PO_EXTRACT_DETAIL_V l2
53023: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
53024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53025: AND xet.event_class_code = C_EVENT_CLASS_CODE
53026: AND l2.event_id = xet.event_id
53027: AND l2.po_distribution_id = l1.po_distribution_id (+) and l2.po_distribution_type = l1.po_distribution_type (+)

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

54443: END source_value
54444: , null source_meaning
54445: FROM xla_events_gt xet
54446: , PA_XLA_BC_PKT_PO_HEADER_V h2
54447: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
54448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54449: AND xet.event_class_code = C_EVENT_CLASS_CODE
54450: AND h2.event_id = xet.event_id
54451:

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

54779: , PA_XLA_BC_PKT_PO_DETAIL_V l1
54780: , PA_XLA_PROJECT_REF_V l3
54781: , PA_XLA_TASK_REF_V l4
54782: , fnd_lookup_values fvl14
54783: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
54784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54785: AND xet.event_class_code = C_EVENT_CLASS_CODE
54786: AND l1.event_id = xet.event_id
54787: AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'

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

57065: END source_value
57066: , null source_meaning
57067: FROM xla_events_gt xet
57068: , PO_REQ_EXTRACT_HEADER_V h2
57069: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
57070: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57071: AND xet.event_class_code = C_EVENT_CLASS_CODE
57072: AND h2.event_id = xet.event_id
57073:

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

57264: , null source_meaning
57265: FROM xla_events_gt xet
57266: , PO_REQ_EXTRACT_DETAIL_V l1
57267: , PO_REQ_LINES_REF_V l3
57268: , (select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
57269: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57270: AND xet.event_class_code = C_EVENT_CLASS_CODE
57271: AND l1.event_id = xet.event_id
57272: AND l1.req_line_id = l3.req_line_id (+)

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

58410: END source_value
58411: , null source_meaning
58412: FROM xla_events_gt xet
58413: , PA_XLA_BC_PKT_REQ_HEADER_V h2
58414: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
58415: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58416: AND xet.event_class_code = C_EVENT_CLASS_CODE
58417: AND h2.event_id = xet.event_id
58418:

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

58716: , PA_XLA_BC_PKT_REQ_DETAIL_V l1
58717: , PA_XLA_PROJECT_REF_V l3
58718: , PA_XLA_TASK_REF_V l4
58719: , fnd_lookup_values fvl14
58720: , (select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
58721: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58722: AND xet.event_class_code = C_EVENT_CLASS_CODE
58723: AND l1.event_id = xet.event_id
58724: AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'