DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on CSI_ITEM_INSTANCES

Line 727: FROM csi_item_instances csi,

723: -- and check line sts same as header sts
724: CURSOR l_asset_sno_csr (p_asset_line IN OKL_K_LINES.ID%TYPE) IS
725: SELECT csi.serial_number,
726: cle_ib.id
727: FROM csi_item_instances csi,
728: okc_k_items cim_ib,
729: okc_line_styles_b lse_ib,
730: okc_k_lines_b cle_ib,
731: okc_line_styles_b lse_inst,

Line 6239: CSI_ITEM_INSTANCES CSI,

6235: QTE.ID QTE_ID
6236: FROM HZ_LOCATIONS HL,
6237: HZ_PARTY_SITES HPS,
6238: HZ_PARTY_SITE_USES HPSU,
6239: CSI_ITEM_INSTANCES CSI,
6240: OKC_K_ITEMS CIM_IB,
6241: OKC_LINE_STYLES_B LSE_IB,
6242: OKC_K_LINES_B CLE_IB,
6243: OKC_LINE_STYLES_B LSE_INST,

Line 6319: CSI_ITEM_INSTANCES CSI,

6315: QTE.ID QTE_ID
6316: FROM HZ_LOCATIONS HL,
6317: HZ_PARTY_SITES HPS,
6318: HZ_PARTY_SITE_USES HPSU,
6319: CSI_ITEM_INSTANCES CSI,
6320: OKC_K_ITEMS CIM_IB,
6321: OKC_LINE_STYLES_B LSE_IB,
6322: OKC_K_LINES_B CLE_IB,
6323: OKC_LINE_STYLES_B LSE_INST,