SELECT xte.ledger_id ledger_id
,xte.source_id_int_1 source_id_int_1
,xte.security_id_int_1 security_id_int_1
,xte.entity_code entity_code
,xte.legal_entity_id legal_entity_id
,xle.event_status_code event_status_code
,xle.process_status_code process_status_code
,xle.event_id
,xle.application_id application_id
,xle.event_id event_id
,xle.event_number event_number
,xle.on_hold_flag on_hold_flag
,xle.event_type_code event_type_code
,xle.event_date event_date
,xte.transaction_number transaction_number
,xle.last_update_date last_update_date
,xle.creation_date creation_date
,xle.transaction_date transaction_date
FROM xla_events xle
,xla_transaction_entities xte
,xla_ledger_options xlo
WHERE xle.entity_id = xte.entity_id
AND xle.application_id = xte.application_id
--选择期间
AND xle.event_date BETWEEN p_start_date AND p_end_date
AND xle.application_id = 200
AND xle.event_status_code IN ('I', 'U')
AND xle.process_status_code IN ('I', 'U', 'R', 'D', 'E')
AND xle.application_id = xlo.application_id
AND xlo.capture_event_flag = 'Y'
AND EXISTS (SELECT 1
FROM gl_ledger_relationships glr1
,gl_ledger_relationships glr2
WHERE glr1.target_ledger_id = xlo.ledger_id
--选择帐套
AND glr2.target_ledger_id = p_ledger_id
AND glr2.source_ledger_id = glr1.source_ledger_id
AND glr2.application_id = glr1.application_id
AND (glr1.target_ledger_id = xte.ledger_id OR
glr1.primary_ledger_id = xte.ledger_id)
AND (glr1.relationship_type_code = 'SUBLEDGER' OR
(glr1.target_ledger_category_code = 'PRIMARY' AND
glr1.relationship_type_code = 'NONE'))
AND glr2.application_id = 101)
AND xte.application_id = 200;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10359218/viewspace-754412/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10359218/viewspace-754412/