APPS.OKS_IMPORT_VALIDATE dependencies on OKC_TIME_CODE_UNITS_B

Line 1606: ,OKC_TIME_CODE_UNITS_B RENGRPER

1602: ,OKC_K_HEADERS_ALL_B HDR
1603: ,OKC_STATUSES_B STS
1604: ,FND_LOOKUPS RENP
1605: ,FND_LOOKUPS RENPOREQ
1606: ,OKC_TIME_CODE_UNITS_B RENGRPER
1607: ,OKC_TIME_CODE_UNITS_B RENESTPER
1608: ,FND_LOOKUPS CR1
1609: ,FND_LOOKUPS CR2
1610: WHERE HST.CATEGORY = CAT.CODE (+)

Line 1607: ,OKC_TIME_CODE_UNITS_B RENESTPER

1603: ,OKC_STATUSES_B STS
1604: ,FND_LOOKUPS RENP
1605: ,FND_LOOKUPS RENPOREQ
1606: ,OKC_TIME_CODE_UNITS_B RENGRPER
1607: ,OKC_TIME_CODE_UNITS_B RENESTPER
1608: ,FND_LOOKUPS CR1
1609: ,FND_LOOKUPS CR2
1610: WHERE HST.CATEGORY = CAT.CODE (+)
1611: AND CAT.CLS_CODE(+) = 'SERVICE'

Line 1923: ,OKC_TIME_CODE_UNITS_B GRPER

1919: ,HZ_CUST_ACCOUNT_ROLES QTC
1920: ,HZ_CONTACT_POINTS QTP
1921: ,HZ_CONTACT_POINTS QTF
1922: ,HZ_CONTACT_POINTS QTE
1923: ,OKC_TIME_CODE_UNITS_B GRPER
1924: ,FND_LOOKUPS FOA
1925: ,OKC_QA_CHECK_LISTS_B QAC
1926: ,OKC_PROCESS_DEFS_B AP
1927: WHERE HST.OPERATING_UNIT_ID = QPS.ORG_ID (+)

Line 2733: ,okc_time_code_units_b BIP

2729: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID
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

Line 3740: ,OKC_TIME_CODE_UNITS_B BIP

3736: AND LST.LAST_BILL_FROM_DATE > LST.END_DATE THEN 'N'
3737: ELSE 'Y' END) LAST_BILL_DATE_V
3738: FROM OKS_INT_LINE_STG_TEMP LST
3739: ,OKS_INT_HEADER_STG_TEMP HDR
3740: ,OKC_TIME_CODE_UNITS_B BIP
3741: ,MTL_UNITS_OF_MEASURE SUOM
3742: ,OKC_TIME_CODE_UNITS_B PUOM
3743: ,OKC_TIME_CODE_UNITS_B USGP
3744: ,FND_LOOKUPS STMI

Line 3742: ,OKC_TIME_CODE_UNITS_B PUOM

3738: FROM OKS_INT_LINE_STG_TEMP LST
3739: ,OKS_INT_HEADER_STG_TEMP HDR
3740: ,OKC_TIME_CODE_UNITS_B BIP
3741: ,MTL_UNITS_OF_MEASURE SUOM
3742: ,OKC_TIME_CODE_UNITS_B PUOM
3743: ,OKC_TIME_CODE_UNITS_B USGP
3744: ,FND_LOOKUPS STMI
3745: ,FND_LOOKUPS UTM
3746: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID

Line 3743: ,OKC_TIME_CODE_UNITS_B USGP

3739: ,OKS_INT_HEADER_STG_TEMP HDR
3740: ,OKC_TIME_CODE_UNITS_B BIP
3741: ,MTL_UNITS_OF_MEASURE SUOM
3742: ,OKC_TIME_CODE_UNITS_B PUOM
3743: ,OKC_TIME_CODE_UNITS_B USGP
3744: ,FND_LOOKUPS STMI
3745: ,FND_LOOKUPS UTM
3746: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3747: AND LST.BILLING_INTERVAL_PERIOD = BIP.UOM_CODE (+)