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_000019_PKG dependencies on CST_XLA_INV_SEC_INVS_REF_V

Line 372053: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

372049: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
372050: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
372051: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
372052: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
372053: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
372054:
372055: ELSE null
372056: END object_name
372057: , CASE r

Line 372135: , CST_XLA_INV_SEC_INVS_REF_V l5

372131: ELSE null
372132: END source_meaning
372133: FROM xla_events_gt xet
372134: , CST_XLA_INV_LINES_V l2
372135: , CST_XLA_INV_SEC_INVS_REF_V l5
372136: , fnd_lookup_values fvl110
372137: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
372138: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
372139: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 372315: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

372311: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
372312: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
372313: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
372314: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
372315: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
372316:
372317: l_array_source_1 t_array_source_1;
372318: l_array_source_2 t_array_source_2;
372319: l_array_source_3 t_array_source_3;

Line 372491: , CST_XLA_INV_SEC_INVS_REF_V l5

372487: , l5.ASSET_INVENTORY source_110
372488: , fvl110.meaning source_110_meaning
372489: FROM xla_events_gt xet
372490: , CST_XLA_INV_LINES_V l2
372491: , CST_XLA_INV_SEC_INVS_REF_V l5
372492: , fnd_lookup_values fvl110
372493: WHERE xet.event_id between x_first_event_id and x_last_event_id
372494: and xet.event_date between p_pad_start_date and p_pad_end_date
372495: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 373974: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

373970: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
373971: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
373972: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
373973: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
373974: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
373975:
373976: ELSE null
373977: END object_name
373978: , CASE r

Line 374056: , CST_XLA_INV_SEC_INVS_REF_V l5

374052: ELSE null
374053: END source_meaning
374054: FROM xla_events_gt xet
374055: , CST_XLA_INV_LINES_V l2
374056: , CST_XLA_INV_SEC_INVS_REF_V l5
374057: , fnd_lookup_values fvl110
374058: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
374059: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
374060: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 374237: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

374233: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
374234: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
374235: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
374236: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
374237: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
374238:
374239: l_array_source_1 t_array_source_1;
374240: l_array_source_2 t_array_source_2;
374241: l_array_source_3 t_array_source_3;

Line 374415: , CST_XLA_INV_SEC_INVS_REF_V l5

374411: , l5.ASSET_INVENTORY source_110
374412: , fvl110.meaning source_110_meaning
374413: FROM xla_events_gt xet
374414: , CST_XLA_INV_LINES_V l2
374415: , CST_XLA_INV_SEC_INVS_REF_V l5
374416: , fnd_lookup_values fvl110
374417: WHERE xet.event_id between x_first_event_id and x_last_event_id
374418: and xet.event_date between p_pad_start_date and p_pad_end_date
374419: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 380996: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

380992: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
380993: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
380994: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
380995: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
380996: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
380997:
380998: ELSE null
380999: END object_name
381000: , CASE r

Line 381078: , CST_XLA_INV_SEC_INVS_REF_V l5

381074: ELSE null
381075: END source_meaning
381076: FROM xla_events_gt xet
381077: , CST_XLA_INV_LINES_V l2
381078: , CST_XLA_INV_SEC_INVS_REF_V l5
381079: , fnd_lookup_values fvl110
381080: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
381081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
381082: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 381258: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

381254: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
381255: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
381256: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
381257: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
381258: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
381259:
381260: l_array_source_1 t_array_source_1;
381261: l_array_source_2 t_array_source_2;
381262: l_array_source_3 t_array_source_3;

Line 381434: , CST_XLA_INV_SEC_INVS_REF_V l5

381430: , l5.ASSET_INVENTORY source_110
381431: , fvl110.meaning source_110_meaning
381432: FROM xla_events_gt xet
381433: , CST_XLA_INV_LINES_V l2
381434: , CST_XLA_INV_SEC_INVS_REF_V l5
381435: , fnd_lookup_values fvl110
381436: WHERE xet.event_id between x_first_event_id and x_last_event_id
381437: and xet.event_date between p_pad_start_date and p_pad_end_date
381438: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 417446: WHEN 13 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

417442: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
417443: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
417444: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
417445: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
417446: WHEN 13 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
417447:
417448: ELSE null
417449: END object_name
417450: , CASE r

Line 417532: , CST_XLA_INV_SEC_INVS_REF_V l7

417528: ELSE null
417529: END source_meaning
417530: FROM xla_events_gt xet
417531: , CST_XLA_INV_LINES_V l4
417532: , CST_XLA_INV_SEC_INVS_REF_V l7
417533: , CST_XLA_RES_OVH_REF_V l12
417534: , fnd_lookup_values fvl110
417535: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
417536: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 417710: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

417706: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
417707: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
417708: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
417709: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
417710: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
417711:
417712: l_array_source_1 t_array_source_1;
417713: l_array_source_2 t_array_source_2;
417714: l_array_source_3 t_array_source_3;

Line 417895: , CST_XLA_INV_SEC_INVS_REF_V l7

417891: , l7.ASSET_INVENTORY source_110
417892: , fvl110.meaning source_110_meaning
417893: FROM xla_events_gt xet
417894: , CST_XLA_INV_LINES_V l4
417895: , CST_XLA_INV_SEC_INVS_REF_V l7
417896: , CST_XLA_RES_OVH_REF_V l12
417897: , fnd_lookup_values fvl110
417898: WHERE xet.event_id between x_first_event_id and x_last_event_id
417899: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 419169: WHEN 13 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

419165: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
419166: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
419167: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
419168: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
419169: WHEN 13 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
419170:
419171: ELSE null
419172: END object_name
419173: , CASE r

Line 419255: , CST_XLA_INV_SEC_INVS_REF_V l7

419251: ELSE null
419252: END source_meaning
419253: FROM xla_events_gt xet
419254: , CST_XLA_INV_LINES_V l4
419255: , CST_XLA_INV_SEC_INVS_REF_V l7
419256: , CST_XLA_RES_OVH_REF_V l12
419257: , fnd_lookup_values fvl110
419258: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
419259: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 419433: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

419429: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
419430: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
419431: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
419432: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
419433: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
419434:
419435: l_array_source_1 t_array_source_1;
419436: l_array_source_2 t_array_source_2;
419437: l_array_source_3 t_array_source_3;

Line 419618: , CST_XLA_INV_SEC_INVS_REF_V l7

419614: , l7.ASSET_INVENTORY source_110
419615: , fvl110.meaning source_110_meaning
419616: FROM xla_events_gt xet
419617: , CST_XLA_INV_LINES_V l4
419618: , CST_XLA_INV_SEC_INVS_REF_V l7
419619: , CST_XLA_RES_OVH_REF_V l12
419620: , fnd_lookup_values fvl110
419621: WHERE xet.event_id between x_first_event_id and x_last_event_id
419622: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 420890: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

420886: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
420887: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
420888: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
420889: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
420890: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
420891:
420892: ELSE null
420893: END object_name
420894: , CASE r

Line 420972: , CST_XLA_INV_SEC_INVS_REF_V l6

420968: ELSE null
420969: END source_meaning
420970: FROM xla_events_gt xet
420971: , CST_XLA_INV_LINES_V l4
420972: , CST_XLA_INV_SEC_INVS_REF_V l6
420973: , fnd_lookup_values fvl110
420974: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
420975: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
420976: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 421148: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

421144: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
421145: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
421146: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
421147: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
421148: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
421149:
421150: l_array_source_1 t_array_source_1;
421151: l_array_source_2 t_array_source_2;
421152: l_array_source_3 t_array_source_3;

Line 421330: , CST_XLA_INV_SEC_INVS_REF_V l6

421326: , l6.ASSET_INVENTORY source_110
421327: , fvl110.meaning source_110_meaning
421328: FROM xla_events_gt xet
421329: , CST_XLA_INV_LINES_V l4
421330: , CST_XLA_INV_SEC_INVS_REF_V l6
421331: , fnd_lookup_values fvl110
421332: WHERE xet.event_id between x_first_event_id and x_last_event_id
421333: and xet.event_date between p_pad_start_date and p_pad_end_date
421334: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 422595: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

422591: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
422592: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
422593: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
422594: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
422595: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
422596:
422597: ELSE null
422598: END object_name
422599: , CASE r

Line 422677: , CST_XLA_INV_SEC_INVS_REF_V l6

422673: ELSE null
422674: END source_meaning
422675: FROM xla_events_gt xet
422676: , CST_XLA_INV_LINES_V l4
422677: , CST_XLA_INV_SEC_INVS_REF_V l6
422678: , fnd_lookup_values fvl110
422679: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
422680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
422681: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 422852: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

422848: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
422849: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
422850: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
422851: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
422852: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
422853:
422854: l_array_source_1 t_array_source_1;
422855: l_array_source_2 t_array_source_2;
422856: l_array_source_3 t_array_source_3;

Line 423032: , CST_XLA_INV_SEC_INVS_REF_V l6

423028: , l6.ASSET_INVENTORY source_110
423029: , fvl110.meaning source_110_meaning
423030: FROM xla_events_gt xet
423031: , CST_XLA_INV_LINES_V l4
423032: , CST_XLA_INV_SEC_INVS_REF_V l6
423033: , fnd_lookup_values fvl110
423034: WHERE xet.event_id between x_first_event_id and x_last_event_id
423035: and xet.event_date between p_pad_start_date and p_pad_end_date
423036: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 428217: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

428213: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
428214: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
428215: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
428216: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
428217: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
428218:
428219: ELSE null
428220: END object_name
428221: , CASE r

Line 428299: , CST_XLA_INV_SEC_INVS_REF_V l6

428295: ELSE null
428296: END source_meaning
428297: FROM xla_events_gt xet
428298: , CST_XLA_INV_LINES_V l4
428299: , CST_XLA_INV_SEC_INVS_REF_V l6
428300: , fnd_lookup_values fvl110
428301: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
428302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
428303: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 428489: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

428485: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
428486: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
428487: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
428488: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
428489: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
428490:
428491: l_array_source_1 t_array_source_1;
428492: l_array_source_2 t_array_source_2;
428493: l_array_source_3 t_array_source_3;

Line 428700: , CST_XLA_INV_SEC_INVS_REF_V l6

428696: , l6.ASSET_INVENTORY source_110
428697: , fvl110.meaning source_110_meaning
428698: FROM xla_events_gt xet
428699: , CST_XLA_INV_LINES_V l4
428700: , CST_XLA_INV_SEC_INVS_REF_V l6
428701: , fnd_lookup_values fvl110
428702: WHERE xet.event_id between x_first_event_id and x_last_event_id
428703: and xet.event_date between p_pad_start_date and p_pad_end_date
428704: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 430086: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'

430082: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
430083: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
430084: WHEN 10 THEN 'CST_XLA_INV_LINES_V'
430085: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
430086: WHEN 12 THEN 'CST_XLA_INV_SEC_INVS_REF_V'
430087:
430088: ELSE null
430089: END object_name
430090: , CASE r

Line 430168: , CST_XLA_INV_SEC_INVS_REF_V l6

430164: ELSE null
430165: END source_meaning
430166: FROM xla_events_gt xet
430167: , CST_XLA_INV_LINES_V l4
430168: , CST_XLA_INV_SEC_INVS_REF_V l6
430169: , fnd_lookup_values fvl110
430170: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
430171: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
430172: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 430358: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;

430354: TYPE t_array_source_94 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
430355: TYPE t_array_source_95 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
430356: TYPE t_array_source_97 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
430357: TYPE t_array_source_108 IS TABLE OF CST_XLA_INV_LINES_V.L_ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
430358: TYPE t_array_source_110 IS TABLE OF CST_XLA_INV_SEC_INVS_REF_V.ASSET_INVENTORY%TYPE INDEX BY BINARY_INTEGER;
430359:
430360: l_array_source_1 t_array_source_1;
430361: l_array_source_2 t_array_source_2;
430362: l_array_source_3 t_array_source_3;

Line 430569: , CST_XLA_INV_SEC_INVS_REF_V l6

430565: , l6.ASSET_INVENTORY source_110
430566: , fvl110.meaning source_110_meaning
430567: FROM xla_events_gt xet
430568: , CST_XLA_INV_LINES_V l4
430569: , CST_XLA_INV_SEC_INVS_REF_V l6
430570: , fnd_lookup_values fvl110
430571: WHERE xet.event_id between x_first_event_id and x_last_event_id
430572: and xet.event_date between p_pad_start_date and p_pad_end_date
430573: and xet.event_type_code = C_EVENT_TYPE_CODE