324: -- Define Types
325: -------------------------------------------------------------------------------
326: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
327: TYPE r_security_info IS RECORD
328: (valuation_method xla_transaction_entities.valuation_method%TYPE
329: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
330: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
331:
332: -------------------------------------------------------------------------------
325: -------------------------------------------------------------------------------
326: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
327: TYPE r_security_info IS RECORD
328: (valuation_method xla_transaction_entities.valuation_method%TYPE
329: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
330: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
331:
332: -------------------------------------------------------------------------------
333: -- Global Constants
326: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
327: TYPE r_security_info IS RECORD
328: (valuation_method xla_transaction_entities.valuation_method%TYPE
329: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
330: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
331:
332: -------------------------------------------------------------------------------
333: -- Global Constants
334: -------------------------------------------------------------------------------
642: ''Invoice Description'' USER_TRX_IDENTIFIER_NAME_10,
643: TIV.DESCRIPTION USER_TRX_IDENTIFIER_VALUE_10
644: FROM
645: AP_SLA_INVOICES_TRANSACTION_V tiv,
646: xla_transaction_entities xte,
647: gl_ledgers gl,
648: -- inline view
649: (SELECT /*+ index(xtb XLA_TRIAL_BALANCES_N1) */ xtb.definition_code,
650: nvl(xtb.applied_to_entity_id,xtb.source_entity_id) entity_id,