DBA Data[Home] [Help]

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on OKC_K_LINES_B

Line 436: OKC_K_LINES_B CLE_IB,

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,
440: OKC_K_LINES_B CLE_MODEL,

Line 438: OKC_K_LINES_B CLE_INST,

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,
442: MTL_SYSTEM_ITEMS MTL,

Line 440: OKC_K_LINES_B CLE_MODEL,

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,
444: OKC_K_LINES_TL CLET_FIN,

Line 445: OKC_K_LINES_B CLE_FIN

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')
448: AND LSE_FIN.id = CLE_FIN.lse_id
449: AND LSE_FIN.lty_code = 'FREE_FORM1'

Line 522: OKC_K_LINES_B OKS_COV_PD_CLEB,

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,
526: OKC_K_LINES_B LNK_SRV_CLEB,

Line 526: OKC_K_LINES_B LNK_SRV_CLEB,

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
529: WHERE OKS_CHRB.scs_code = 'SERVICE'
530: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id

Line 528: OKC_K_LINES_B FIN_LINE

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
529: WHERE OKS_CHRB.scs_code = 'SERVICE'
530: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
531: AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id
532: AND OKS_COV_PD_LSE.lty_code = 'COVER_PROD'

Line 552: OKC_K_LINES_B OKS_COV_PD_CLEB,

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,
556: OKC_K_LINES_B LNK_SRV_CLEB,

Line 556: OKC_K_LINES_B LNK_SRV_CLEB,

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,
559: OKL_TXL_QUOTE_LINES_B TQL
560: WHERE OKS_CHRB.scs_code = 'SERVICE'

Line 558: OKC_K_LINES_B FIN_LINE,

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,
559: OKL_TXL_QUOTE_LINES_B TQL
560: WHERE OKS_CHRB.scs_code = 'SERVICE'
561: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
562: AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id

Line 789: FROM OKC_K_LINES_B CLE

785:
786: -- Get the asset details
787: CURSOR asset_dtls_csr ( p_id IN NUMBER) IS
788: SELECT CLE.dnz_chr_id
789: FROM OKC_K_LINES_B CLE
790: WHERE CLE.id = p_id;
791:
792: l_source VARCHAR2(100);
793: l_transaction_id VARCHAR2(100);