DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on FND_TERRITORIES_TL

Line 2757: FROM FND_TERRITORIES_TL T, FND_TERRITORIES B

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,
2760: AR_LOOKUPS ARL,
2761: MFG_LOOKUPS MFL, mtl_customer_item_xrefs xref