DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_COMMODITY_CODES

Line 2755: MTL_COMMODITY_CODES MCC,

2751: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
2752: AND NVL(ACCT_SITE.ORG_ID,- 99) = NVL(LOC_ASSIGN.ORG_ID,- 99)
2753: AND NVL(ACCT_SITE.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1, 10))),- 99)) =
2754: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1, 1),' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),- 99)) RAD,
2755: MTL_COMMODITY_CODES MCC,
2756: MTL_CUSTOMER_ITEMS MCIM, ( SELECT B.TERRITORY_CODE
2757: FROM FND_TERRITORIES_TL T, FND_TERRITORIES B
2758: WHERE B.TERRITORY_CODE = T.TERRITORY_CODE
2759: AND T.LANGUAGE = USERENV('LANG')) TERR,