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_000020_BC_PKG dependencies on CST_XLA_RCV_LINES_V

Line 14048: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

14044: FROM (
14045: SELECT xet.event_id event_id
14046: , l2.line_number line_number
14047: , CASE r
14048: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
14049: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
14050:
14051: ELSE null
14052: END object_name

Line 14049: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

14045: SELECT xet.event_id event_id
14046: , l2.line_number line_number
14047: , CASE r
14048: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
14049: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
14050:
14051: ELSE null
14052: END object_name
14053: , CASE r

Line 14080: , CST_XLA_RCV_LINES_V l2

14076: ELSE null
14077: END source_value
14078: , null source_meaning
14079: FROM xla_events_gt xet
14080: , CST_XLA_RCV_LINES_V l2
14081: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
14082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
14083: AND xet.event_class_code = C_EVENT_CLASS_CODE
14084: AND l2.event_id = xet.event_id

Line 14234: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

14230: TYPE t_array_source_30 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
14231: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
14232: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
14233:
14234: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
14235: TYPE t_array_source_29 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
14236:
14237: l_array_source_9 t_array_source_9;
14238: l_array_source_9_meaning t_array_lookup_meaning;

Line 14235: TYPE t_array_source_29 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

14231: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
14232: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
14233:
14234: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
14235: TYPE t_array_source_29 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
14236:
14237: l_array_source_9 t_array_source_9;
14238: l_array_source_9_meaning t_array_lookup_meaning;
14239: l_array_source_11 t_array_source_11;

Line 14361: , CST_XLA_RCV_LINES_V l2

14357: , l2.LINE_NUMBER
14358: , l2.DISTRIBUTION_IDENTIFIER source_8
14359: , l2.RCV_ACCOUNTING_LINE_TYPE source_29
14360: FROM xla_events_gt xet
14361: , CST_XLA_RCV_LINES_V l2
14362: WHERE xet.event_id between x_first_event_id and x_last_event_id
14363: and xet.event_date between p_pad_start_date and p_pad_end_date
14364: and xet.event_class_code = C_EVENT_CLASS_CODE
14365: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 30820: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

30816: FROM (
30817: SELECT xet.event_id event_id
30818: , l2.line_number line_number
30819: , CASE r
30820: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
30821: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
30822:
30823: ELSE null
30824: END object_name

Line 30821: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

30817: SELECT xet.event_id event_id
30818: , l2.line_number line_number
30819: , CASE r
30820: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
30821: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
30822:
30823: ELSE null
30824: END object_name
30825: , CASE r

Line 30852: , CST_XLA_RCV_LINES_V l2

30848: ELSE null
30849: END source_value
30850: , null source_meaning
30851: FROM xla_events_gt xet
30852: , CST_XLA_RCV_LINES_V l2
30853: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
30854: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30855: AND xet.event_class_code = C_EVENT_CLASS_CODE
30856: AND l2.event_id = xet.event_id

Line 31005: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

31001: TYPE t_array_source_30 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31002: TYPE t_array_source_32 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31003: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31004:
31005: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31006: TYPE t_array_source_29 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
31007:
31008: l_array_source_9 t_array_source_9;
31009: l_array_source_9_meaning t_array_lookup_meaning;

Line 31006: TYPE t_array_source_29 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

31002: TYPE t_array_source_32 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31003: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31004:
31005: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31006: TYPE t_array_source_29 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
31007:
31008: l_array_source_9 t_array_source_9;
31009: l_array_source_9_meaning t_array_lookup_meaning;
31010: l_array_source_11 t_array_source_11;

Line 31130: , CST_XLA_RCV_LINES_V l2

31126: , l2.LINE_NUMBER
31127: , l2.DISTRIBUTION_IDENTIFIER source_8
31128: , l2.RCV_ACCOUNTING_LINE_TYPE source_29
31129: FROM xla_events_gt xet
31130: , CST_XLA_RCV_LINES_V l2
31131: WHERE xet.event_id between x_first_event_id and x_last_event_id
31132: and xet.event_date between p_pad_start_date and p_pad_end_date
31133: and xet.event_class_code = C_EVENT_CLASS_CODE
31134: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id