View: INVBV_CUSTOMER_ITEMS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_CUSTOMER_ITEMS

View Text

SELECT PARTY.PARTY_NAME
, CUIT.CUSTOMER_ITEM_NUMBER
, AD.COUNTRY
, AD.ADDRESS1
, AD.ADDRESS2
, AD.ADDRESS3
, AD.ADDRESS4
, AD.CITY
, AD.POSTAL_CODE
, AD.STATE
, AD.PROVINCE
, AD.COUNTY
, LO.MEANING
, '_LA:CUIT.ITEM_DEFINITION_LEVEL:MFG_LOOKUPS:INV_ITEM_DEFINITION_LEVEL:MEANING'
, CUIT.CUSTOMER_ITEM_DESC
, CUIT.MIN_FILL_PERCENTAGE
, CUIT.DEMAND_TOLERANCE_POSITIVE
, CUIT.DEMAND_TOLERANCE_NEGATIVE
, '_LA:CUIT.DEP_PLAN_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CUIT.DEP_PLAN_PRIOR_BLD_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CUIT.INACTIVE_FLAG:FND_LOOKUPS:YES_NO_REVERSE:MEANING'
, CUIT.CUSTOMER_CATEGORY_CODE
, CUIT.CUSTOMER_ITEM_ID
, CUIT.CUSTOMER_ID
, CUIT.ADDRESS_ID
, CUIT.MODEL_CUSTOMER_ITEM_ID
, CUIT.COMMODITY_CODE_ID
, CUIT.MASTER_CONTAINER_ITEM_ID
, CUIT.CONTAINER_ITEM_ORG_ID
, CUIT.DETAIL_CONTAINER_ITEM_ID
, CUIT.CREATION_DATE
, CUIT.CREATED_BY
, CUIT.LAST_UPDATE_DATE
, CUIT.LAST_UPDATED_BY
FROM AR_LOOKUPS LO
, (SELECT LOC.ADDRESS_STYLE
, LOC.COUNTRY
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
, ACCT_SITE.STATUS
FROM HZ_LOC_ASSIGNMENTS LOC_ASSIGN
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND NVL(ACCT_SITE.ORG_ID
, - 99) = NVL(LOC_ASSIGN.ORG_ID
, - 99)) AD
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, MTL_CUSTOMER_ITEMS CUIT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUIT.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUIT.ADDRESS_ID = AD.ADDRESS_ID(+)
AND CUIT.CUSTOMER_CATEGORY_CODE = LO.LOOKUP_CODE(+)
AND LO.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY' WITH READ ONLY

Columns