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

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

6075: , PO_HEADERS_REF_V h5
6076: , PSA_CST_XLA_UPG_V h6
6077: , fnd_lookup_values fvl13
6078: , fnd_lookup_values fvl37
6079: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
6080: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6081: AND xet.event_class_code = C_EVENT_CLASS_CODE
6082: AND h1.event_id = xet.event_id
6083: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h4.po_header_id (+) and h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

6186: END source_value
6187: , null source_meaning
6188: FROM xla_events_gt xet
6189: , CST_XLA_RCV_LINES_V l2
6190: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
6191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6192: AND xet.event_class_code = C_EVENT_CLASS_CODE
6193: AND l2.event_id = xet.event_id
6194:

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

7371: , PO_REQ_HEADERS_REF_V h6
7372: , PSA_CST_XLA_UPG_V h7
7373: , fnd_lookup_values fvl13
7374: , fnd_lookup_values fvl37
7375: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
7376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7377: AND xet.event_class_code = C_EVENT_CLASS_CODE
7378: AND h1.event_id = xet.event_id
7379: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h4.bus_flow_req_dist_id=h5.req_distribution_id (+) AND h4.bus_flow_req_id = h6.req_id (+) AND h4.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

7482: END source_value
7483: , null source_meaning
7484: FROM xla_events_gt xet
7485: , CST_XLA_INV_LINES_V l2
7486: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
7487: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7488: AND xet.event_class_code = C_EVENT_CLASS_CODE
7489: AND l2.event_id = xet.event_id
7490:

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

8634: , PO_REQ_HEADERS_REF_V h6
8635: , PSA_CST_XLA_UPG_V h7
8636: , fnd_lookup_values fvl13
8637: , fnd_lookup_values fvl37
8638: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
8639: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8640: AND xet.event_class_code = C_EVENT_CLASS_CODE
8641: AND h1.event_id = xet.event_id
8642: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h4.bus_flow_req_dist_id=h5.req_distribution_id (+) AND h4.bus_flow_req_id = h6.req_id (+) AND h4.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

8750: END source_value
8751: , null source_meaning
8752: FROM xla_events_gt xet
8753: , CST_XLA_INV_LINES_V l2
8754: , (select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
8755: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8756: AND xet.event_class_code = C_EVENT_CLASS_CODE
8757: AND l2.event_id = xet.event_id
8758:

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

9837: FROM xla_events_gt xet
9838: , CST_XLA_INV_HEADERS_V h1
9839: , fnd_lookup_values fvl13
9840: , fnd_lookup_values fvl37
9841: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
9842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9843: AND xet.event_class_code = C_EVENT_CLASS_CODE
9844: AND h1.event_id = xet.event_id
9845: AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

9983: END source_value
9984: , null source_meaning
9985: FROM xla_events_gt xet
9986: , CST_XLA_INV_LINES_V l2
9987: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
9988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9989: AND xet.event_class_code = C_EVENT_CLASS_CODE
9990: AND l2.event_id = xet.event_id
9991:

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

11015: FROM xla_events_gt xet
11016: , CST_XLA_INV_HEADERS_V h1
11017: , fnd_lookup_values fvl13
11018: , fnd_lookup_values fvl37
11019: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
11020: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11021: AND xet.event_class_code = C_EVENT_CLASS_CODE
11022: AND h1.event_id = xet.event_id
11023: AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

11161: END source_value
11162: , null source_meaning
11163: FROM xla_events_gt xet
11164: , CST_XLA_INV_LINES_V l2
11165: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
11166: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11167: AND xet.event_class_code = C_EVENT_CLASS_CODE
11168: AND l2.event_id = xet.event_id
11169:

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

12257: , PO_HEADERS_REF_V h5
12258: , PSA_CST_XLA_PEA_UPG_V h6
12259: , fnd_lookup_values fvl13
12260: , fnd_lookup_values fvl37
12261: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
12262: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12263: AND xet.event_class_code = C_EVENT_CLASS_CODE
12264: AND h1.event_id = xet.event_id
12265: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h4.po_header_id (+) and h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.ref_rcv_accounting_event_id = h6.accounting_event_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

12368: END source_value
12369: , null source_meaning
12370: FROM xla_events_gt xet
12371: , CST_XLA_RCV_LINES_V l2
12372: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
12373: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12374: AND xet.event_class_code = C_EVENT_CLASS_CODE
12375: AND l2.event_id = xet.event_id
12376:

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

13559: , PO_HEADERS_REF_V h6
13560: , PSA_CST_XLA_UPG_V h7
13561: , fnd_lookup_values fvl13
13562: , fnd_lookup_values fvl37
13563: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13565: AND xet.event_class_code = C_EVENT_CLASS_CODE
13566: AND h1.event_id = xet.event_id
13567: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h4.txn_po_header_id = h5.po_header_id (+) and h4.txn_po_distribution_id = h5.po_distribution_id (+) AND h4.txn_po_header_id = h6.po_header_id (+) AND h4.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

13675: END source_value
13676: , null source_meaning
13677: FROM xla_events_gt xet
13678: , CST_XLA_INV_LINES_V l2
13679: , (select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
13680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13681: AND xet.event_class_code = C_EVENT_CLASS_CODE
13682: AND l2.event_id = xet.event_id
13683: