VIEW: APPS.CSM_PO_LOC_ASS_ALL_V

Source

View Text - Preformatted

SELECT acc.access_id , loc.location_id , loc.site_use_id, loc.customer_id , cas.party_site_id, loc.organization_id , loc.subinventory , loc.org_id, loc.ADDRESS_ID, loc.REQUEST_ID, hrl.telephone_number_1,hrl.telephone_number_2,hrl.telephone_number_3,acc.resource_type FROM csm_po_loc_ass_all_acc acc, po_location_associations_all loc, hz_cust_acct_sites_all cas, hr_locations_all hrl WHERE acc.user_id = asg_base.get_user_id AND acc.location_id = loc.location_id and acc.org_id=loc.org_id and cas.cust_acct_site_id = loc.address_id and cas.org_id=loc.org_id and loc.location_id=hrl.location_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, LOC.LOCATION_ID
, LOC.SITE_USE_ID
, LOC.CUSTOMER_ID
, CAS.PARTY_SITE_ID
, LOC.ORGANIZATION_ID
, LOC.SUBINVENTORY
, LOC.ORG_ID
, LOC.ADDRESS_ID
, LOC.REQUEST_ID
, HRL.TELEPHONE_NUMBER_1
, HRL.TELEPHONE_NUMBER_2
, HRL.TELEPHONE_NUMBER_3
, ACC.RESOURCE_TYPE
FROM CSM_PO_LOC_ASS_ALL_ACC ACC
, PO_LOCATION_ASSOCIATIONS_ALL LOC
, HZ_CUST_ACCT_SITES_ALL CAS
, HR_LOCATIONS_ALL HRL
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.LOCATION_ID = LOC.LOCATION_ID
AND ACC.ORG_ID=LOC.ORG_ID
AND CAS.CUST_ACCT_SITE_ID = LOC.ADDRESS_ID
AND CAS.ORG_ID=LOC.ORG_ID
AND LOC.LOCATION_ID=HRL.LOCATION_ID