Oracle Applications: Key Flex Field Structures & How to Retrieve Information

http://www.notesbit.com/index.php/oracle-applications/11i-scripts/oracle-applications-key-flex-field-structures-how-to-retrieve-information/

This script is used to extract order header details from backend.

SELECT ra.customer_number,
hl.address1,
hl.address2,
hl.city,
hl.state,
hl.postal_code,
hl.country,
hl.province,
hl.county
FROM oe_order_headers_all ooh,
hz_cust_site_uses_all hcsu,
hz_cust_acct_sites_all hcas,
hz_party_sites hps,
hz_locations hl,
ra_customers ra
WHERE 1 = 1
AND ooh.invoice_to_org_id = hcsu.site_use_id
AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND hcas.party_site_id = hps.party_site_id
AND hps.location_id = hl.location_id
AND hcas.cust_account_id = ra.customer_id
AND order_number = &Order_number

Oracle Financial Training

http://www.aboutoracleapps.com/2007/07/gl-concepts-1.html