APPS.AHL_UMP_UF_PVT dependencies on CSI_ITEM_INSTANCES

Line 859: FROM csi_item_instances

855: l_exists VARCHAR2(1);
856:
857: CURSOR instance_check_csr(p_csi_item_instance_id IN NUMBER) IS
858: SELECT 'x'
859: FROM csi_item_instances
860: WHERE instance_id = p_csi_item_instance_id;
861:
862:
863: BEGIN

Line 1984: FROM csi_item_instances a, ahl_unit_config_headers b

1980: AND c.status = c_complete_status;
1981: --
1982: CURSOR ahl_item_id_from_uc_header_csr(c_uc_header_id IN NUMBER) IS
1983: SELECT a.inventory_item_id
1984: FROM csi_item_instances a, ahl_unit_config_headers b
1985: WHERE a.instance_id = b.csi_item_instance_id
1986: AND b.unit_config_header_id = c_uc_header_id;
1987: --
1988: CURSOR ahl_check_pc_id_csr(p_pc_node_id IN NUMBER,

Line 2697: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c

2693: a.ATTRIBUTE12 ,
2694: a.ATTRIBUTE13 ,
2695: a.ATTRIBUTE14 ,
2696: a.ATTRIBUTE15
2697: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2698: WHERE a.uf_header_id = b.uf_header_id
2699: AND b.inventory_item_id = c.inventory_item_id
2700: AND c.instance_id = p_csi_item_instance_id;
2701:

Line 2731: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c

2727: a.ATTRIBUTE12 ,
2728: a.ATTRIBUTE13 ,
2729: a.ATTRIBUTE14 ,
2730: a.ATTRIBUTE15
2731: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2732: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2733: AND a.uf_header_id = b.uf_header_id
2734: AND b.inventory_item_id = c.inventory_item_id
2735: AND c.instance_id = p_csi_item_instance_id;