DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on CSI_ITEM_INSTANCES

Line 716: FROM csi_item_instances csi,

712: -- and check line sts same as header sts
713: CURSOR l_asset_sno_csr (p_asset_line IN OKL_K_LINES.ID%TYPE) IS
714: SELECT csi.serial_number,
715: cle_ib.id
716: FROM csi_item_instances csi,
717: okc_k_items cim_ib,
718: okc_line_styles_b lse_ib,
719: okc_k_lines_b cle_ib,
720: okc_line_styles_b lse_inst,

Line 6029: CSI_ITEM_INSTANCES CSI,

6025: QTE.ID QTE_ID
6026: FROM HZ_LOCATIONS HL,
6027: HZ_PARTY_SITES HPS,
6028: HZ_PARTY_SITE_USES HPSU,
6029: CSI_ITEM_INSTANCES CSI,
6030: OKC_K_ITEMS CIM_IB,
6031: OKC_LINE_STYLES_B LSE_IB,
6032: OKC_K_LINES_B CLE_IB,
6033: OKC_LINE_STYLES_B LSE_INST,

Line 6109: CSI_ITEM_INSTANCES CSI,

6105: QTE.ID QTE_ID
6106: FROM HZ_LOCATIONS HL,
6107: HZ_PARTY_SITES HPS,
6108: HZ_PARTY_SITE_USES HPSU,
6109: CSI_ITEM_INSTANCES CSI,
6110: OKC_K_ITEMS CIM_IB,
6111: OKC_LINE_STYLES_B LSE_IB,
6112: OKC_K_LINES_B CLE_IB,
6113: OKC_LINE_STYLES_B LSE_INST,