471: ,1
472: ,50) CUSTOMER_NAME
473: FROM
474: HZ_PARTIES PARTY,
475: HZ_CUST_ACCOUNTS CUST_ACCT,
476: OE_ORDER_HEADERS_ALL OH
477: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
478: AND OH.HEADER_ID = O_ID
479: AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
499: ,1
500: ,50) CUSTOMER_NAME
501: FROM
502: HZ_PARTIES PARTY,
503: HZ_CUST_ACCOUNTS CUST_ACCT,
504: OE_ORDER_HEADERS_ALL OH
505: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
506: AND OH.HEADER_ID = O_ID
507: AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;