DBA Data[Home] [Help]

APPS.OKL_VSS_WF dependencies on OKC_K_LINES_B

Line 343: OKC_K_LINES_B USAGE,

339: SELECT CN.COUNTER_ID COUNTER_NUMBER, CN.NAME COUNTER_NAME,
340: KHR.CONTRACT_NUMBER CONTRACT_NUMBER, ASSET.NAME ASSET_NUMBER
341: FROM
342: OKC_K_LINES_TL ASSET,
343: OKC_K_LINES_B USAGE,
344: OKC_K_ITEMS UITEM,
345: OKC_K_LINES_B OKS,
346: OKC_K_LINES_B OKSU,
347: OKC_K_ITEMS OKSITEM,

Line 345: OKC_K_LINES_B OKS,

341: FROM
342: OKC_K_LINES_TL ASSET,
343: OKC_K_LINES_B USAGE,
344: OKC_K_ITEMS UITEM,
345: OKC_K_LINES_B OKS,
346: OKC_K_LINES_B OKSU,
347: OKC_K_ITEMS OKSITEM,
348: CSI_COUNTERS_VL CN,
349: OKC_K_ITEMS ASSET_ITEM,

Line 346: OKC_K_LINES_B OKSU,

342: OKC_K_LINES_TL ASSET,
343: OKC_K_LINES_B USAGE,
344: OKC_K_ITEMS UITEM,
345: OKC_K_LINES_B OKS,
346: OKC_K_LINES_B OKSU,
347: OKC_K_ITEMS OKSITEM,
348: CSI_COUNTERS_VL CN,
349: OKC_K_ITEMS ASSET_ITEM,
350: OKC_K_REL_OBJS REL,

Line 352: OKC_K_LINES_B USUB_LINE

348: CSI_COUNTERS_VL CN,
349: OKC_K_ITEMS ASSET_ITEM,
350: OKC_K_REL_OBJS REL,
351: OKC_K_HEADERS_B KHR,
352: OKC_K_LINES_B USUB_LINE
353: WHERE
354: CN.COUNTER_ID = p_counter_id AND
355: USAGE.DNZ_CHR_ID = KHR.ID AND
356: KHR.ID = USAGE.CHR_ID AND