APPS.OKS_EXTWARPRGM_PVT dependencies on CSI_ITEM_INSTANCES

Line 6909: FROM csi_item_instances

6905:
6906: CURSOR l_refnum_csr (p_cp_id NUMBER)
6907: IS
6908: SELECT instance_number
6909: FROM csi_item_instances
6910: WHERE instance_id = p_cp_id;
6911:
6912: l_ref_num VARCHAR2 (30);
6913: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

Line 7797: FROM csi_item_instances

7793:
7794: CURSOR l_refnum_csr (p_cp_id NUMBER)
7795: IS
7796: SELECT instance_number
7797: FROM csi_item_instances
7798: WHERE instance_id = p_cp_id;
7799:
7800: l_ref_num VARCHAR2 (30);
7801: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

Line 8743: FROM csi_item_instances

8739:
8740: CURSOR l_refnum_csr (p_cp_id NUMBER)
8741: IS
8742: SELECT instance_number
8743: FROM csi_item_instances
8744: WHERE instance_id = p_cp_id;
8745:
8746: Cursor l_hdr_sts_csr(p_hdr_id Number)
8747: Is

Line 9554: FROM csi_item_instances

9550:
9551: CURSOR l_refnum_csr (p_cp_id NUMBER)
9552: IS
9553: SELECT instance_number
9554: FROM csi_item_instances
9555: WHERE instance_id = p_cp_id;
9556: /* Added for Bug#14325727 */
9557: CURSOR l_serv_csr (p_serv_id NUMBER)
9558: IS

Line 10549: From csi_item_instances csi

10545: Select csi.last_oe_order_line_id Original_order_line_id
10546: ,csi.inventory_item_id
10547: ,csi.quantity
10548: ,csi.unit_of_measure uom_code
10549: From csi_item_instances csi
10550: Where csi.instance_id = p_kdtl_rec.old_cp_id;
10551: */
10552: CURSOR l_line_sts_csr (p_line_id NUMBER)
10553: IS

Line 14184: FROM csi_item_instances

14180:
14181: CURSOR l_refnum_csr (p_cp_id NUMBER)
14182: IS
14183: SELECT instance_number
14184: FROM csi_item_instances
14185: WHERE instance_id = p_cp_id;
14186:
14187:
14188: Cursor l_hdr_sts_csr(p_hdr_id Number)

Line 14959: FROM csi_item_instances

14955:
14956: CURSOR l_refnum_csr (p_cp_id NUMBER)
14957: IS
14958: SELECT instance_number
14959: FROM csi_item_instances
14960: WHERE instance_id = p_cp_id;
14961:
14962: l_ref_num VARCHAR2 (30);
14963: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

Line 15817: FROM csi_item_instances

15813: */
15814: CURSOR l_refnum_csr (p_cp_id NUMBER)
15815: IS
15816: SELECT instance_number
15817: FROM csi_item_instances
15818: WHERE instance_id = p_cp_id;
15819:
15820: l_ref_num VARCHAR2 (30);
15821: l_parameters VARCHAR2 (2000);