DBA Data[Home] [Help]

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on OKC_LINE_STYLES_B

Line 435: OKC_LINE_STYLES_B LSE_IB,

431: CSI.serial_number serial_number,
432: CSI.quantity asset_quantity
433: FROM CSI_ITEM_INSTANCES CSI,
434: OKC_K_ITEMS CIM_IB,
435: OKC_LINE_STYLES_B LSE_IB,
436: OKC_K_LINES_B CLE_IB,
437: OKC_LINE_STYLES_B LSE_INST,
438: OKC_K_LINES_B CLE_INST,
439: OKC_LINE_STYLES_B LSE_MODEL,

Line 437: OKC_LINE_STYLES_B LSE_INST,

433: FROM CSI_ITEM_INSTANCES CSI,
434: OKC_K_ITEMS CIM_IB,
435: OKC_LINE_STYLES_B LSE_IB,
436: OKC_K_LINES_B CLE_IB,
437: OKC_LINE_STYLES_B LSE_INST,
438: OKC_K_LINES_B CLE_INST,
439: OKC_LINE_STYLES_B LSE_MODEL,
440: OKC_K_LINES_B CLE_MODEL,
441: OKC_K_ITEMS CIM_MODEL,

Line 439: OKC_LINE_STYLES_B LSE_MODEL,

435: OKC_LINE_STYLES_B LSE_IB,
436: OKC_K_LINES_B CLE_IB,
437: OKC_LINE_STYLES_B LSE_INST,
438: OKC_K_LINES_B CLE_INST,
439: OKC_LINE_STYLES_B LSE_MODEL,
440: OKC_K_LINES_B CLE_MODEL,
441: OKC_K_ITEMS CIM_MODEL,
442: MTL_SYSTEM_ITEMS MTL,
443: OKC_LINE_STYLES_B LSE_FIN,

Line 443: OKC_LINE_STYLES_B LSE_FIN,

439: OKC_LINE_STYLES_B LSE_MODEL,
440: OKC_K_LINES_B CLE_MODEL,
441: OKC_K_ITEMS CIM_MODEL,
442: MTL_SYSTEM_ITEMS MTL,
443: OKC_LINE_STYLES_B LSE_FIN,
444: OKC_K_LINES_TL CLET_FIN,
445: OKC_K_LINES_B CLE_FIN
446: WHERE CLE_FIN.id = CLET_FIN.id
447: AND CLET_FIN.LANGUAGE = USERENV('LANG')

Line 521: OKC_LINE_STYLES_B OKS_COV_PD_LSE,

517: -- Get all serviced assets for the contract
518: CURSOR get_k_serviced_assets_csr (p_khr_id IN NUMBER) IS
519: SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
520: FROM OKC_K_HEADERS_B OKS_CHRB,
521: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
522: OKC_K_LINES_B OKS_COV_PD_CLEB,
523: OKC_K_REL_OBJS KREL,
524: OKC_LINE_STYLES_B LNK_SRV_LSE,
525: OKC_STATUSES_B LNK_SRV_STS,

Line 524: OKC_LINE_STYLES_B LNK_SRV_LSE,

520: FROM OKC_K_HEADERS_B OKS_CHRB,
521: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
522: OKC_K_LINES_B OKS_COV_PD_CLEB,
523: OKC_K_REL_OBJS KREL,
524: OKC_LINE_STYLES_B LNK_SRV_LSE,
525: OKC_STATUSES_B LNK_SRV_STS,
526: OKC_K_LINES_B LNK_SRV_CLEB,
527: OKC_K_ITEMS LNK_SRV_CIM,
528: OKC_K_LINES_B FIN_LINE

Line 551: OKC_LINE_STYLES_B OKS_COV_PD_LSE,

547: -- Get all serviced assets for the quote
548: CURSOR get_q_serviced_assets_csr (p_qte_id IN NUMBER) IS
549: SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
550: FROM OKC_K_HEADERS_B OKS_CHRB,
551: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
552: OKC_K_LINES_B OKS_COV_PD_CLEB,
553: OKC_K_REL_OBJS KREL,
554: OKC_LINE_STYLES_B LNK_SRV_LSE,
555: OKC_STATUSES_B LNK_SRV_STS,

Line 554: OKC_LINE_STYLES_B LNK_SRV_LSE,

550: FROM OKC_K_HEADERS_B OKS_CHRB,
551: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
552: OKC_K_LINES_B OKS_COV_PD_CLEB,
553: OKC_K_REL_OBJS KREL,
554: OKC_LINE_STYLES_B LNK_SRV_LSE,
555: OKC_STATUSES_B LNK_SRV_STS,
556: OKC_K_LINES_B LNK_SRV_CLEB,
557: OKC_K_ITEMS LNK_SRV_CIM,
558: OKC_K_LINES_B FIN_LINE,