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 CST_XLA_RCV_LINES_V

Line 6157: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

6153: FROM (
6154: SELECT xet.event_id event_id
6155: , l2.line_number line_number
6156: , CASE r
6157: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
6158: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
6159:
6160: ELSE null
6161: END object_name

Line 6158: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

6154: SELECT xet.event_id event_id
6155: , l2.line_number line_number
6156: , CASE r
6157: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
6158: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
6159:
6160: ELSE null
6161: END object_name
6162: , CASE r

Line 6189: , CST_XLA_RCV_LINES_V l2

6185: ELSE null
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

Line 6343: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

6339: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6340: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6341: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6342:
6343: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
6344: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6345:
6346: l_array_source_2 t_array_source_2;
6347: l_array_source_3 t_array_source_3;

Line 6344: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

6340: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6341: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6342:
6343: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
6344: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6345:
6346: l_array_source_2 t_array_source_2;
6347: l_array_source_3 t_array_source_3;
6348: l_array_source_7 t_array_source_7;

Line 6470: , CST_XLA_RCV_LINES_V l2

6466: , l2.LINE_NUMBER
6467: , l2.DISTRIBUTION_IDENTIFIER source_12
6468: , l2.RCV_ACCOUNTING_LINE_TYPE source_25
6469: FROM xla_events_gt xet
6470: , CST_XLA_RCV_LINES_V l2
6471: WHERE xet.event_id between x_first_event_id and x_last_event_id
6472: and xet.event_date between p_pad_start_date and p_pad_end_date
6473: and xet.event_class_code = C_EVENT_CLASS_CODE
6474: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 12339: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

12335: FROM (
12336: SELECT xet.event_id event_id
12337: , l2.line_number line_number
12338: , CASE r
12339: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
12340: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
12341:
12342: ELSE null
12343: END object_name

Line 12340: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

12336: SELECT xet.event_id event_id
12337: , l2.line_number line_number
12338: , CASE r
12339: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
12340: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
12341:
12342: ELSE null
12343: END object_name
12344: , CASE r

Line 12371: , CST_XLA_RCV_LINES_V l2

12367: ELSE null
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

Line 12524: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

12520: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
12521: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
12522: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12523:
12524: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12525: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12526:
12527: l_array_source_2 t_array_source_2;
12528: l_array_source_7 t_array_source_7;

Line 12525: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

12521: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
12522: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12523:
12524: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12525: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12526:
12527: l_array_source_2 t_array_source_2;
12528: l_array_source_7 t_array_source_7;
12529: l_array_source_8 t_array_source_8;

Line 12649: , CST_XLA_RCV_LINES_V l2

12645: , l2.LINE_NUMBER
12646: , l2.DISTRIBUTION_IDENTIFIER source_12
12647: , l2.RCV_ACCOUNTING_LINE_TYPE source_25
12648: FROM xla_events_gt xet
12649: , CST_XLA_RCV_LINES_V l2
12650: WHERE xet.event_id between x_first_event_id and x_last_event_id
12651: and xet.event_date between p_pad_start_date and p_pad_end_date
12652: and xet.event_class_code = C_EVENT_CLASS_CODE
12653: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id