R12: Purchasing(PO) Subledger Accounting (XLA) Drilldown Queries

1. select rl.* from po_requisition_lines_all rl, po_requisition_headers_all rh

where rh.Requisition_Header_id = rl.Requisition_Header_id
and rh.Requisition_Header_id = 4563

2. select * from xla.xla_transaction_entities where source_id_int_1 = 4563
and application_id = 201;

3. select * from xla_events where entity_id= (select entity_id from xla.xla_transaction_entities where source_id_int_1 = 4563 and application_id = 201);

4. select * from xla_ae_headers where event_id in ( select event_id from xla_events where entity_id= (select entity_id from xla.xla_transaction_entities where source_id_int_1 = 4563 and application_id = 201));

5. select * from xla_ae_lines where ae_header_id in ( select ae_header_id from xla_ae_headers where event_id in ( select event_id from xla_events where entity_id= (select entity_id from xla.xla_transaction_entities where source_id_int_1 = 4563 and application_id = 201)));

6. select * from po_headers_all where po_header_id= 14867;

7. select * from po_distributions_all where po_header_id= 14867;

8. select * from xla.xla_transaction_entities where source_id_int_1 = 14867 and application_id = 201;

9. select * from xla_events where entity_id= (select entity_id from xla.xla_transaction_entities where source_id_int_1 = 14867 and application_id = 201);

10. select * from xla_ae_headers where event_id in (select event_id from xla_events where entity_id= (select entity_id from xla.xla_transaction_entities where source_id_int_1 = 14867and application_id = 201));

11. select * from xla_ae_lines where ae_header_id in (select ae_header_id from xla_ae_headers where event_id in (select event_id from xla_events where entity_id=(select entity_id from la.xla_transaction_entities where source_id_int_1 = 14867 and application_id = 201)));

No comments:

Post a Comment