View: AP_SHIP_BILL_TO_LOCATIONS_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_SHIP_BILL_TO_LOCATIONS_V

View Text

SELECT LOT.LOCATION_CODE
, LOC.LOCATION_ID
, LOT.DESCRIPTION
, LOC.INVENTORY_ORGANIZATION_ID
, LOC.SHIP_TO_SITE_FLAG
, LOC.BILL_TO_SITE_FLAG
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOT
WHERE SYSDATE < NVL(LOC.INACTIVE_DATE
, SYSDATE+1)
AND LOC.LOCATION_ID = LOT.LOCATION_ID
AND LOT.LANGUAGE = USERENV('LANG')
AND (NVL(LOC.BUSINESS_GROUP_ID
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99))

Columns