APPS.OKL_ACTIVATE_IB_PVT dependencies on CSI_ITEM_INSTANCES

Line 1507: FROM CSI_ITEM_INSTANCES CSI

1503: p_inv_item_id IN NUMBER,
1504: p_inv_mstr_org_id IN NUMBER,
1505: p_khr_start_date IN DATE) IS
1506: SELECT INSTANCE_ID
1507: FROM CSI_ITEM_INSTANCES CSI
1508: WHERE SERIAL_NUMBER = p_serial_number
1509: AND INVENTORY_ITEM_ID = p_inv_item_id
1510: AND INV_MASTER_ORGANIZATION_ID = p_inv_mstr_org_id
1511: AND INSTANCE_STATUS_ID IN (SELECT INSTANCE_STATUS_ID

Line 2503: from csi_item_instances

2499: --Cursor to get owner party and account and location info from install base
2500: ---------------------------------------------------------------------------
2501: Cursor l_csi_csr(p_instance_id in number) is
2502: Select *
2503: from csi_item_instances
2504: where instance_id = p_instance_id;
2505:
2506: l_csi_rec l_csi_csr%ROWTYPE;
2507:

Line 3090: FROM csi_item_instances csi_item

3086: AND ib_cim.dnz_chr_id = p_orig_chr_id;
3087:
3088: CURSOR srl_num_old_csr(p_instance_id IN NUMBER) IS
3089: SELECT csi_item.serial_number
3090: FROM csi_item_instances csi_item
3091: WHERE csi_item.instance_id = p_instance_id;
3092:
3093: l_srl_num_old_rec srl_num_old_csr%ROWTYPE;
3094:

Line 3115: FROM csi_item_instances csi_item,

3111: -- Get Original Inventory Item
3112: CURSOR orig_instance_dtls_csr (p_fin_ast_cle_id IN NUMBER,
3113: p_chr_id IN NUMBER) is
3114: SELECT csi_item.inventory_item_id
3115: FROM csi_item_instances csi_item,
3116: okc_k_items ib_cim,
3117: okc_k_lines_b ib_cle,
3118: okc_k_lines_b inst_cle,
3119: okc_statuses_b inst_sts