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 PO_HEADERS_REF_V

Line 5970: WHEN 1 THEN 'PO_HEADERS_REF_V'

5966: FROM (
5967: SELECT xet.event_id event_id
5968: , 0 line_number
5969: , CASE r
5970: WHEN 1 THEN 'PO_HEADERS_REF_V'
5971: WHEN 2 THEN 'PO_DISTS_REF_V'
5972: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
5973: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

Line 5982: WHEN 13 THEN 'PO_HEADERS_REF_V'

5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
5979: WHEN 10 THEN 'CST_XLA_RCV_HEADERS_V'
5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'
5981: WHEN 12 THEN 'PSA_CST_XLA_UPG_V'
5982: WHEN 13 THEN 'PO_HEADERS_REF_V'
5983: WHEN 14 THEN 'CST_XLA_RCV_REF_V'
5984: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'
5985:
5986: ELSE null

Line 6075: , PO_HEADERS_REF_V h5

6071: FROM xla_events_gt xet
6072: , CST_XLA_RCV_HEADERS_V h1
6073: , CST_XLA_RCV_REF_V h3
6074: , PO_DISTS_REF_V h4
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)

Line 6327: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

6323: --
6324: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6325: --
6326:
6327: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6329: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
6330: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 6339: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
6336: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6337: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6338: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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;

Line 6417: , PO_HEADERS_REF_V h5

6413: FROM xla_events_gt xet
6414: , CST_XLA_RCV_HEADERS_V h1
6415: , CST_XLA_RCV_REF_V h3
6416: , PO_DISTS_REF_V h4
6417: , PO_HEADERS_REF_V h5
6418: , PSA_CST_XLA_UPG_V h6
6419: , fnd_lookup_values fvl13
6420: , fnd_lookup_values fvl37
6421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 12157: WHEN 1 THEN 'PO_HEADERS_REF_V'

12153: FROM (
12154: SELECT xet.event_id event_id
12155: , 0 line_number
12156: , CASE r
12157: WHEN 1 THEN 'PO_HEADERS_REF_V'
12158: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
12159: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

Line 12167: WHEN 11 THEN 'PO_HEADERS_REF_V'

12163: WHEN 7 THEN 'PO_DISTS_REF_V'
12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
12165: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
12166: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
12167: WHEN 11 THEN 'PO_HEADERS_REF_V'
12168: WHEN 12 THEN 'CST_XLA_RCV_REF_V'
12169: WHEN 13 THEN 'PSA_CST_XLA_PEA_UPG_V'
12170: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
12171:

Line 12257: , PO_HEADERS_REF_V h5

12253: FROM xla_events_gt xet
12254: , CST_XLA_RCV_HEADERS_V h1
12255: , CST_XLA_RCV_REF_V h3
12256: , PO_DISTS_REF_V h4
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)

Line 12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

12505: --
12506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12507: --
12508:
12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
12511: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12519: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
12517: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12518: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12519: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%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:

Line 12596: , PO_HEADERS_REF_V h5

12592: FROM xla_events_gt xet
12593: , CST_XLA_RCV_HEADERS_V h1
12594: , CST_XLA_RCV_REF_V h3
12595: , PO_DISTS_REF_V h4
12596: , PO_HEADERS_REF_V h5
12597: , PSA_CST_XLA_PEA_UPG_V h6
12598: , fnd_lookup_values fvl13
12599: , fnd_lookup_values fvl37
12600: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 13453: WHEN 1 THEN 'PO_HEADERS_REF_V'

13449: FROM (
13450: SELECT xet.event_id event_id
13451: , 0 line_number
13452: , CASE r
13453: WHEN 1 THEN 'PO_HEADERS_REF_V'
13454: WHEN 2 THEN 'PO_DISTS_REF_V'
13455: WHEN 3 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
13456: WHEN 4 THEN 'CST_XLA_INV_REF_V'
13457: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 13466: WHEN 14 THEN 'PO_HEADERS_REF_V'

13462: WHEN 10 THEN 'PO_DISTS_REF_V'
13463: WHEN 11 THEN 'CST_XLA_INV_REF_V'
13464: WHEN 12 THEN 'CST_XLA_INV_REF_V'
13465: WHEN 13 THEN 'PSA_CST_XLA_UPG_V'
13466: WHEN 14 THEN 'PO_HEADERS_REF_V'
13467: WHEN 15 THEN 'CST_XLA_INV_HEADERS_V'
13468:
13469: ELSE null
13470: END object_name

Line 13559: , PO_HEADERS_REF_V h6

13555: , CST_XLA_INV_HEADERS_V h1
13556: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13557: , CST_XLA_INV_REF_V h4
13558: , PO_DISTS_REF_V h5
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)

Line 13816: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

13812: --
13813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13814: --
13815:
13816: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
13817: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
13818: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
13819: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
13820: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 13829: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

13825: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
13826: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
13827: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13828: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
13829: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
13830: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13831:
13832: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
13833: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 13909: , PO_HEADERS_REF_V h6

13905: , CST_XLA_INV_HEADERS_V h1
13906: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13907: , CST_XLA_INV_REF_V h4
13908: , PO_DISTS_REF_V h5
13909: , PO_HEADERS_REF_V h6
13910: , PSA_CST_XLA_UPG_V h7
13911: , fnd_lookup_values fvl13
13912: , fnd_lookup_values fvl37
13913: WHERE xet.event_date between p_pad_start_date and p_pad_end_date