VIEW: APPS.CSM_HZ_CUST_SITE_USES_ALL_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.SITE_USE_ID , B.CUST_ACCT_SITE_ID , B.SITE_USE_CODE , B.PRIMARY_FLAG , B.STATUS , B.LOCATION , B.CONTACT_ID , B.BILL_TO_SITE_USE_ID , B.ORIG_SYSTEM_REFERENCE , B.SIC_CODE , B.PAYMENT_TERM_ID , B.GSA_INDICATOR , B.SHIP_PARTIAL , B.SHIP_VIA , B.FOB_POINT , B.ORDER_TYPE_ID , B.PRICE_LIST_ID , B.FREIGHT_TERM , B.WAREHOUSE_ID , B.TERRITORY_ID FROM HZ_CUST_SITE_USES_ALL B , CSM_HZ_CUST_SITE_USES_ALL_ACC ACC WHERE B.SITE_USE_ID = ACC.SITE_USE_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.SITE_USE_ID
, B.CUST_ACCT_SITE_ID
, B.SITE_USE_CODE
, B.PRIMARY_FLAG
, B.STATUS
, B.LOCATION
, B.CONTACT_ID
, B.BILL_TO_SITE_USE_ID
, B.ORIG_SYSTEM_REFERENCE
, B.SIC_CODE
, B.PAYMENT_TERM_ID
, B.GSA_INDICATOR
, B.SHIP_PARTIAL
, B.SHIP_VIA
, B.FOB_POINT
, B.ORDER_TYPE_ID
, B.PRICE_LIST_ID
, B.FREIGHT_TERM
, B.WAREHOUSE_ID
, B.TERRITORY_ID
FROM HZ_CUST_SITE_USES_ALL B
, CSM_HZ_CUST_SITE_USES_ALL_ACC ACC
WHERE B.SITE_USE_ID = ACC.SITE_USE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID