DBA Data[Home] [Help]

APPS.XLA_TB_AP_REPORT_PVT dependencies on XLA_TRANSACTION_ENTITIES

Line 427: xla_transaction_entities xte,

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,

Line 709: (valuation_method xla_transaction_entities.valuation_method%TYPE

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: -------------------------------------------------------------------------------

Line 710: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE

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

Line 711: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);

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: -------------------------------------------------------------------------------

Line 1028: xla_transaction_entities xte,

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 */