DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on OKC_TIME_CODE_UNITS_TL

Line 2734: ,okc_time_code_units_tl BIPTL /*Added for bug:9019205*/

2730: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA
2731: WHERE LSE.APPLICATION_ID = FA.APPLICATION_ID
2732: AND FA.APPLICATION_SHORT_NAME = 'OKS') LS
2733: ,okc_time_code_units_b BIP
2734: ,okc_time_code_units_tl BIPTL /*Added for bug:9019205*/
2735: ,(SELECT distinct(LNI.LINE_INTERFACE_ID)
2736: ,COUNT(DISTINCT QPI.ROWID) OVER (PARTITION BY LNI.ROWID) QPI_COUNT
2737: ,MAX(LNI.PRICE_LIST_ID) OVER (PARTITION BY LNI.ROWID) QPI_ID -- PRICE LIST ID based on Id
2738: ,(CASE WHEN HST.CONTRACT_CURRENCY_CODE = QPI.CURRENCY_CODE THEN 'Y'