DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_TIME_CODE_UNITS_B

Line 940: FROM okc_time_code_units_b tcui

936: , max(tcui.tce_code)
937: keep (dense_rank first order by tcui.quantity) as tce_code
938: , max(tcui.quantity)
939: keep (dense_rank first order by tcui.quantity) as quantity
940: FROM okc_time_code_units_b tcui
941: WHERE tcui.active_flag = 'Y'
942: GROUP BY tcui.uom_code
943: ) tcu
944: -- salesrep

Line 1668: FROM okc_time_code_units_b tcui

1664: , max(tcui.tce_code)
1665: keep (dense_rank first order by tcui.quantity) as tce_code
1666: , max(tcui.quantity)
1667: keep (dense_rank first order by tcui.quantity) as quantity
1668: FROM okc_time_code_units_b tcui
1669: WHERE tcui.active_flag = 'Y'
1670: GROUP BY tcui.uom_code
1671: ) tcu
1672: WHERE 1=1