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 2476: from csi_item_instances

2472: --Cursor to get owner party and account and location info from install base
2473: ---------------------------------------------------------------------------
2474: Cursor l_csi_csr(p_instance_id in number) is
2475: Select *
2476: from csi_item_instances
2477: where instance_id = p_instance_id;
2478:
2479: l_csi_rec l_csi_csr%ROWTYPE;
2480:

Line 3053: FROM csi_item_instances csi_item

3049: AND ib_cim.dnz_chr_id = p_orig_chr_id;
3050:
3051: CURSOR srl_num_old_csr(p_instance_id IN NUMBER) IS
3052: SELECT csi_item.serial_number
3053: FROM csi_item_instances csi_item
3054: WHERE csi_item.instance_id = p_instance_id;
3055:
3056: l_srl_num_old_rec srl_num_old_csr%ROWTYPE;
3057:

Line 3078: FROM csi_item_instances csi_item,

3074: -- Get Original Inventory Item
3075: CURSOR orig_instance_dtls_csr (p_fin_ast_cle_id IN NUMBER,
3076: p_chr_id IN NUMBER) is
3077: SELECT csi_item.inventory_item_id
3078: FROM csi_item_instances csi_item,
3079: okc_k_items ib_cim,
3080: okc_k_lines_b ib_cle,
3081: okc_k_lines_b inst_cle,
3082: okc_statuses_b inst_sts