APPS.OKS_EXTWARPRGM_PVT dependencies on CSI_ITEM_INSTANCES

Line 6728: FROM csi_item_instances

6724:
6725: CURSOR l_refnum_csr (p_cp_id NUMBER)
6726: IS
6727: SELECT instance_number
6728: FROM csi_item_instances
6729: WHERE instance_id = p_cp_id;
6730:
6731: l_ref_num VARCHAR2 (30);
6732: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

Line 7603: FROM csi_item_instances

7599:
7600: CURSOR l_refnum_csr (p_cp_id NUMBER)
7601: IS
7602: SELECT instance_number
7603: FROM csi_item_instances
7604: WHERE instance_id = p_cp_id;
7605:
7606: l_ref_num VARCHAR2 (30);
7607: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

Line 8512: FROM csi_item_instances

8508:
8509: CURSOR l_refnum_csr (p_cp_id NUMBER)
8510: IS
8511: SELECT instance_number
8512: FROM csi_item_instances
8513: WHERE instance_id = p_cp_id;
8514:
8515: Cursor l_hdr_sts_csr(p_hdr_id Number)
8516: Is

Line 9323: FROM csi_item_instances

9319:
9320: CURSOR l_refnum_csr (p_cp_id NUMBER)
9321: IS
9322: SELECT instance_number
9323: FROM csi_item_instances
9324: WHERE instance_id = p_cp_id;
9325:
9326: CURSOR l_serv_csr (p_serv_id NUMBER)
9327: IS

Line 10301: From csi_item_instances csi

10297: Select csi.last_oe_order_line_id Original_order_line_id
10298: ,csi.inventory_item_id
10299: ,csi.quantity
10300: ,csi.unit_of_measure uom_code
10301: From csi_item_instances csi
10302: Where csi.instance_id = p_kdtl_rec.old_cp_id;
10303: */
10304: CURSOR l_line_sts_csr (p_line_id NUMBER)
10305: IS

Line 13899: FROM csi_item_instances

13895:
13896: CURSOR l_refnum_csr (p_cp_id NUMBER)
13897: IS
13898: SELECT instance_number
13899: FROM csi_item_instances
13900: WHERE instance_id = p_cp_id;
13901:
13902:
13903: Cursor l_hdr_sts_csr(p_hdr_id Number)

Line 14674: FROM csi_item_instances

14670:
14671: CURSOR l_refnum_csr (p_cp_id NUMBER)
14672: IS
14673: SELECT instance_number
14674: FROM csi_item_instances
14675: WHERE instance_id = p_cp_id;
14676:
14677: l_ref_num VARCHAR2 (30);
14678: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

Line 15519: FROM csi_item_instances

15515:
15516: CURSOR l_refnum_csr (p_cp_id NUMBER)
15517: IS
15518: SELECT instance_number
15519: FROM csi_item_instances
15520: WHERE instance_id = p_cp_id;
15521:
15522: l_ref_num VARCHAR2 (30);
15523: l_parameters VARCHAR2 (2000);