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,
732: okc_k_lines_b cle_inst,
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,
6244: OKC_K_LINES_B CLE_INST,
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,
6324: OKC_K_LINES_B CLE_INST,