APPS.CSI_UTL_PKG dependencies on CSI_T_II_RELATIONSHIPS

Line 4446: FROM csi_t_ii_relationships

4442: ORDER BY RELATIONSHIP_ID DESC;
4443:
4444: CURSOR check_csi_t_ii_rel(p_instance_id IN NUMBER) IS
4445: SELECT txn_relationship_id, object_id, relationship_type_code
4446: FROM csi_t_ii_relationships
4447: WHERE object_id = p_instance_id
4448: AND relationship_type_code = 'COMPONENT-OF'
4449: AND active_end_date IS NULL;
4450:

Line 4908: /* Check for csi_t_ii_relationships for BOM expl */

4904: debug('item status is '||l_item_status);
4905:
4906: /* If tranfer component flag is 'Y' then do more checking*/
4907: IF l_transfer_components_flag = 'Y' THEN
4908: /* Check for csi_t_ii_relationships for BOM expl */
4909: l_t_ii_count := 0;
4910: FOR i in check_csi_t_ii_rel(l_new_instance_id)
4911: LOOP
4912: l_t_ii_count := l_t_ii_count + 1;

Line 6125: FROM csi_t_ii_relationships

6121:
6122: CURSOR oe_tld_relns_cur (c_orig_oe_tld IN NUMBER)
6123: IS
6124: SELECT *
6125: FROM csi_t_ii_relationships
6126: WHERE (( subject_type = 'T' AND subject_id = c_orig_oe_tld)
6127: OR ( object_type = 'T' AND object_id = c_orig_oe_tld))
6128: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6129:

Line 6296: FROM csi_t_ii_relationships

6292: IS
6293: CURSOR txn_ii_relns_cur (c_txn_line_detail_id IN NUMBER)
6294: IS
6295: SELECT *
6296: FROM csi_t_ii_relationships
6297: WHERE (( subject_type = 'T' AND subject_id = c_txn_line_detail_id )
6298: OR (object_type = 'T' AND object_id = c_txn_line_detail_id ))
6299: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6300: