eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ASO_I_SEARCH_ORDERS_V

Source

View Text - Preformatted


SELECT oh.header_id , oh.last_update_date , oh.creation_date , oh.order_number , oh.version_number , oh.ORDERED_DATE , oh.SOLD_TO_ORG_ID , customer_party.party_name , customer_party.party_number , null , null , oh.TRANSACTIONAL_CURR_CODE , oh.CUST_PO_NUMBER , oh.SOLD_TO_CONTACT_ID , customer_contact_party.person_first_name sold_to_contact_first_name , customer_contact_party.person_last_name sold_to_contact_last_name , ASO_ORDER_INT.Get_Header_Status(oh.header_id) , ASO_ORDER_INT.Total_Order_Price(oh.header_id) from OE_ORDER_HEADERS OH, hz_parties customer_party, hz_cust_accounts customer_account, hz_org_contacts customer_contact, hz_relationships party_relationship, hz_parties customer_contact_party WHERE oh.sold_to_org_id = customer_account.cust_account_id(+) and customer_account.party_id = customer_party.party_id (+) and oh.sold_to_contact_id = customer_contact.org_contact_id(+) and customer_contact.party_relationship_id = party_relationship.relationship_id (+) and party_relationship.subject_id = customer_contact_party.party_id(+)

View Text - HTML Formatted

SELECT OH.HEADER_ID
, OH.LAST_UPDATE_DATE
, OH.CREATION_DATE
, OH.ORDER_NUMBER
, OH.VERSION_NUMBER
, OH.ORDERED_DATE
, OH.SOLD_TO_ORG_ID
, CUSTOMER_PARTY.PARTY_NAME
, CUSTOMER_PARTY.PARTY_NUMBER
, NULL
, NULL
, OH.TRANSACTIONAL_CURR_CODE
, OH.CUST_PO_NUMBER
, OH.SOLD_TO_CONTACT_ID
, CUSTOMER_CONTACT_PARTY.PERSON_FIRST_NAME SOLD_TO_CONTACT_FIRST_NAME
, CUSTOMER_CONTACT_PARTY.PERSON_LAST_NAME SOLD_TO_CONTACT_LAST_NAME
, ASO_ORDER_INT.GET_HEADER_STATUS(OH.HEADER_ID)
, ASO_ORDER_INT.TOTAL_ORDER_PRICE(OH.HEADER_ID)
FROM OE_ORDER_HEADERS OH
, HZ_PARTIES CUSTOMER_PARTY
, HZ_CUST_ACCOUNTS CUSTOMER_ACCOUNT
, HZ_ORG_CONTACTS CUSTOMER_CONTACT
, HZ_RELATIONSHIPS PARTY_RELATIONSHIP
, HZ_PARTIES CUSTOMER_CONTACT_PARTY
WHERE OH.SOLD_TO_ORG_ID = CUSTOMER_ACCOUNT.CUST_ACCOUNT_ID(+)
AND CUSTOMER_ACCOUNT.PARTY_ID = CUSTOMER_PARTY.PARTY_ID (+)
AND OH.SOLD_TO_CONTACT_ID = CUSTOMER_CONTACT.ORG_CONTACT_ID(+)
AND CUSTOMER_CONTACT.PARTY_RELATIONSHIP_ID = PARTY_RELATIONSHIP.RELATIONSHIP_ID (+)
AND PARTY_RELATIONSHIP.SUBJECT_ID = CUSTOMER_CONTACT_PARTY.PARTY_ID(+)