APPS.OKS_IMPORT_VALIDATE dependencies on OKC_TIME_CODE_UNITS_B

Line 1576: ,OKC_TIME_CODE_UNITS_B RENGRPER

1572: ,OKC_K_HEADERS_ALL_B HDR
1573: ,OKC_STATUSES_B STS
1574: ,FND_LOOKUPS RENP
1575: ,FND_LOOKUPS RENPOREQ
1576: ,OKC_TIME_CODE_UNITS_B RENGRPER
1577: ,OKC_TIME_CODE_UNITS_B RENESTPER
1578: ,FND_LOOKUPS CR1
1579: ,FND_LOOKUPS CR2
1580: WHERE HST.CATEGORY = CAT.CODE (+)

Line 1577: ,OKC_TIME_CODE_UNITS_B RENESTPER

1573: ,OKC_STATUSES_B STS
1574: ,FND_LOOKUPS RENP
1575: ,FND_LOOKUPS RENPOREQ
1576: ,OKC_TIME_CODE_UNITS_B RENGRPER
1577: ,OKC_TIME_CODE_UNITS_B RENESTPER
1578: ,FND_LOOKUPS CR1
1579: ,FND_LOOKUPS CR2
1580: WHERE HST.CATEGORY = CAT.CODE (+)
1581: AND CAT.CLS_CODE(+) = 'SERVICE'

Line 1893: ,OKC_TIME_CODE_UNITS_B GRPER

1889: ,HZ_CUST_ACCOUNT_ROLES QTC
1890: ,HZ_CONTACT_POINTS QTP
1891: ,HZ_CONTACT_POINTS QTF
1892: ,HZ_CONTACT_POINTS QTE
1893: ,OKC_TIME_CODE_UNITS_B GRPER
1894: ,FND_LOOKUPS FOA
1895: ,OKC_QA_CHECK_LISTS_B QAC
1896: ,OKC_PROCESS_DEFS_B AP
1897: WHERE HST.OPERATING_UNIT_ID = QPS.ORG_ID (+)

Line 3688: ,OKC_TIME_CODE_UNITS_B BIP

3684: AND LST.LAST_BILL_FROM_DATE > LST.END_DATE THEN 'N'
3685: ELSE 'Y' END) LAST_BILL_DATE_V
3686: FROM OKS_INT_LINE_STG_TEMP LST
3687: ,OKS_INT_HEADER_STG_TEMP HDR
3688: ,OKC_TIME_CODE_UNITS_B BIP
3689: ,MTL_UNITS_OF_MEASURE SUOM
3690: ,OKC_TIME_CODE_UNITS_B PUOM
3691: ,OKC_TIME_CODE_UNITS_B USGP
3692: ,FND_LOOKUPS STMI

Line 3690: ,OKC_TIME_CODE_UNITS_B PUOM

3686: FROM OKS_INT_LINE_STG_TEMP LST
3687: ,OKS_INT_HEADER_STG_TEMP HDR
3688: ,OKC_TIME_CODE_UNITS_B BIP
3689: ,MTL_UNITS_OF_MEASURE SUOM
3690: ,OKC_TIME_CODE_UNITS_B PUOM
3691: ,OKC_TIME_CODE_UNITS_B USGP
3692: ,FND_LOOKUPS STMI
3693: ,FND_LOOKUPS UTM
3694: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID

Line 3691: ,OKC_TIME_CODE_UNITS_B USGP

3687: ,OKS_INT_HEADER_STG_TEMP HDR
3688: ,OKC_TIME_CODE_UNITS_B BIP
3689: ,MTL_UNITS_OF_MEASURE SUOM
3690: ,OKC_TIME_CODE_UNITS_B PUOM
3691: ,OKC_TIME_CODE_UNITS_B USGP
3692: ,FND_LOOKUPS STMI
3693: ,FND_LOOKUPS UTM
3694: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3695: AND LST.BILLING_INTERVAL_PERIOD = BIP.UOM_CODE (+)