423: tb.intercompany_segment_value,
424: tb.management_segment_value
425: FROM
426: AP_SLA_INVOICES_TRANSACTION_V tiv,
427: xla_transaction_entities xte,
428: -- inline view
429: ( SELECT /*+ parallel(xtb) leading(xtb) NO_MERGE */ --added hint bug#8409806 bug9133956
430: xtb.definition_code,
431: nvl(xtb.applied_to_entity_id,xtb.source_entity_id) entity_id,
705: -- Define Types
706: -------------------------------------------------------------------------------
707: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
708: TYPE r_security_info IS RECORD
709: (valuation_method xla_transaction_entities.valuation_method%TYPE
710: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
711: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
712:
713: -------------------------------------------------------------------------------
706: -------------------------------------------------------------------------------
707: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
708: TYPE r_security_info IS RECORD
709: (valuation_method xla_transaction_entities.valuation_method%TYPE
710: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
711: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
712:
713: -------------------------------------------------------------------------------
714: -- Global Constants
707: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
708: TYPE r_security_info IS RECORD
709: (valuation_method xla_transaction_entities.valuation_method%TYPE
710: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
711: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
712:
713: -------------------------------------------------------------------------------
714: -- Global Constants
715: -------------------------------------------------------------------------------
1024: ''Invoice Description'' USER_TRX_IDENTIFIER_NAME_10,
1025: TIV.DESCRIPTION USER_TRX_IDENTIFIER_VALUE_10
1026: FROM
1027: AP_SLA_INVOICES_TRANSACTION_V tiv,
1028: xla_transaction_entities xte,
1029: gl_ledgers gl,
1030: -- inline view
1031: ( SELECT /*+ parallel(xtb) leading(xtb) NO_MERGE */ --added hint bug#8409806 -- leading hint for bug:9165098
1032: /* added NO_MERGE for bug:9473043 */