APPS.OKS_IBINT_PUB dependencies on CSI_ITEM_INSTANCES

Line 24: from csi_item_instances csi , oe_order_lines_all ol

20: Return BOOLEAN
21: IS
22: CURSOR l_parent_cp_csr IS
23: Select csi.instance_id
24: from csi_item_instances csi , oe_order_lines_all ol
25: where ol.line_id = csi.last_oe_order_line_id
26: and ol.inventory_item_id = csi.inventory_item_id
27: and ol.line_id = p_order_line_id ;
28:

Line 352: from csi_item_instances

348: where org_id = p_org_id;
349:
350: Cursor l_refnum_csr(p_cp_id NUMBER) IS
351: select instance_number
352: from csi_item_instances
353: where instance_id = p_cp_id;
354:
355: Cursor l_subscr_csr(p_instance_id Number) Is
356: Select instance_id

Line 379: From CSI_ITEM_INSTANCES Csi,

375: Cursor Cust_csr(p_id Number) is
376:
377: Select csi.last_oe_agreement_id Product_agreement_id
378: ,oh.transactional_curr_code Original_order_currency_code
379: From CSI_ITEM_INSTANCES Csi,
380: OE_ORDER_HEADERS_ALL OH,
381: OE_ORDER_LINES_ALL OL
382: Where csi.instance_id = p_id
383: And csi.last_oe_order_line_id = ol.line_id

Line 2047: from csi_item_instances

2043: Where oks.instance_id = tmp.old_customer_product_id;
2044:
2045: Cursor l_refnum_csr(p_cp_id NUMBER) IS
2046: select instance_number
2047: from csi_item_instances
2048: where instance_id = p_cp_id;
2049:
2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 3531: FROM CSI_ITEM_INSTANCES CII,

3527:
3528: CURSOR prod_party_validity_csr (p_chr_id NUMBER,p_cust_prod_id NUMBER)
3529: IS
3530: SELECT 'Y'
3531: FROM CSI_ITEM_INSTANCES CII,
3532: CSI_I_ORG_ASSIGNMENTS CIOA,
3533: OE_ORDER_LINES_ALL OOL,
3534: OKC_K_PARTY_ROLES_B k_party,
3535: okc_k_headers_all_b okh

Line 3565: FROM CSI_ITEM_INSTANCES CII,

3561:
3562: CURSOR prod_uom_validity_csr(p_cust_prod_id NUMBER)
3563: IS
3564: SELECT 'Y'
3565: FROM CSI_ITEM_INSTANCES CII,
3566: (SELECT UNIT_OF_MEASURE , UOM_CODE ,DISABLE_DATE
3567: FROM MTL_UNITS_OF_MEASURE_TL
3568: WHERE LANGUAGE = USERENV('LANG')) UOM
3569: WHERE CII.Unit_Of_Measure = UOM.uom_code

Line 3576: FROM CSI_ITEM_INSTANCES CII

3572:
3573: CURSOR prod_sts_chk_csr(p_cust_prod_id NUMBER)
3574: IS
3575: SELECT 'Y'
3576: FROM CSI_ITEM_INSTANCES CII
3577: WHERE CII.instance_status_id IN
3578: (SELECT CIS.instance_status_id
3579: FROM CSI_INSTANCE_STATUSES CIS
3580: WHERE CIS.service_order_allowed_flag = 'Y'

Line 3587: FROM CSI_ITEM_INSTANCES CII,

3583:
3584: CURSOR item_serviceable_csr(p_chr_id NUMBER,p_cust_prod_id NUMBER)
3585: IS
3586: SELECT 'Y'
3587: FROM CSI_ITEM_INSTANCES CII,
3588: MTL_SYSTEM_ITEMS_B_KFV IT,
3589: OKC_K_HEADERS_ALL_B OKH
3590: WHERE IT.inventory_item_id = CII.inventory_item_id
3591: AND IT.organization_id = OKH.inv_organization_id