DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000020_BC_PKG dependencies on CST_XLA_RCV_HEADERS_V

Line 13861: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

13857: FROM (
13858: SELECT xet.event_id event_id
13859: , 0 line_number
13860: , CASE r
13861: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
13862: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
13863: WHEN 3 THEN 'PO_HEADERS_REF_V'
13864: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
13865: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

Line 13862: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

13858: SELECT xet.event_id event_id
13859: , 0 line_number
13860: , CASE r
13861: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
13862: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
13863: WHEN 3 THEN 'PO_HEADERS_REF_V'
13864: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
13865: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
13866: WHEN 6 THEN 'CST_XLA_RCV_REF_V'

Line 13875: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'

13871: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
13872: WHEN 12 THEN 'PO_HEADERS_REF_V'
13873: WHEN 13 THEN 'CST_XLA_RCV_REF_V'
13874: WHEN 14 THEN 'PO_DISTS_REF_V'
13875: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'
13876:
13877: ELSE null
13878: END object_name
13879: , CASE r

Line 13963: , CST_XLA_RCV_HEADERS_V h1

13959:
13960: ELSE null
13961: END source_meaning
13962: FROM xla_events_gt xet
13963: , CST_XLA_RCV_HEADERS_V h1
13964: , CST_XLA_RCV_REF_V h3
13965: , PO_DISTS_REF_V h4
13966: , PO_HEADERS_REF_V h5
13967: , PSA_CST_XLA_UPG_V h6

Line 14218: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

14214: --
14215: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
14216: --
14217:
14218: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
14219: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
14220: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
14221: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
14222: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 14219: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

14215: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
14216: --
14217:
14218: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
14219: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
14220: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
14221: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
14222: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
14223: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 14232: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

14228: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
14229: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%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:

Line 14305: , CST_XLA_RCV_HEADERS_V h1

14301: , h4.RESERVED_FLAG source_31
14302: , h1.TRANSFER_TO_GL_INDICATOR source_42
14303: , fvl42.meaning source_42_meaning
14304: FROM xla_events_gt xet
14305: , CST_XLA_RCV_HEADERS_V h1
14306: , CST_XLA_RCV_REF_V h3
14307: , PO_DISTS_REF_V h4
14308: , PO_HEADERS_REF_V h5
14309: , PSA_CST_XLA_UPG_V h6

Line 30638: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

30634: FROM (
30635: SELECT xet.event_id event_id
30636: , 0 line_number
30637: , CASE r
30638: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
30639: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
30640: WHEN 3 THEN 'PO_HEADERS_REF_V'
30641: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
30642: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

Line 30639: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

30635: SELECT xet.event_id event_id
30636: , 0 line_number
30637: , CASE r
30638: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
30639: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
30640: WHEN 3 THEN 'PO_HEADERS_REF_V'
30641: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
30642: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
30643: WHEN 6 THEN 'CST_XLA_RCV_REF_V'

Line 30651: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

30647: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
30648: WHEN 11 THEN 'PO_HEADERS_REF_V'
30649: WHEN 12 THEN 'CST_XLA_RCV_REF_V'
30650: WHEN 13 THEN 'PSA_CST_XLA_PEA_UPG_V'
30651: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
30652:
30653: ELSE null
30654: END object_name
30655: , CASE r

Line 30735: , CST_XLA_RCV_HEADERS_V h1

30731:
30732: ELSE null
30733: END source_meaning
30734: FROM xla_events_gt xet
30735: , CST_XLA_RCV_HEADERS_V h1
30736: , CST_XLA_RCV_REF_V h3
30737: , PO_DISTS_REF_V h4
30738: , PO_HEADERS_REF_V h5
30739: , PSA_CST_XLA_PEA_UPG_V h6

Line 30990: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

30986: --
30987: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
30988: --
30989:
30990: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
30991: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
30992: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
30993: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
30994: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 30991: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

30987: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
30988: --
30989:
30990: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
30991: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
30992: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
30993: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
30994: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
30995: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 31003: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

30999: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31000: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%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:

Line 31074: , CST_XLA_RCV_HEADERS_V h1

31070: , h6.CST_PEA_ENC_UPG_OPTION source_32
31071: , h1.TRANSFER_TO_GL_INDICATOR source_42
31072: , fvl42.meaning source_42_meaning
31073: FROM xla_events_gt xet
31074: , CST_XLA_RCV_HEADERS_V h1
31075: , CST_XLA_RCV_REF_V h3
31076: , PO_DISTS_REF_V h4
31077: , PO_HEADERS_REF_V h5
31078: , PSA_CST_XLA_PEA_UPG_V h6