APPS.CSI_UTL_PKG dependencies on CSI_T_II_RELATIONSHIPS

Line 4488: FROM csi_t_ii_relationships

4484: ORDER BY RELATIONSHIP_ID DESC;
4485:
4486: CURSOR check_csi_t_ii_rel(p_instance_id IN NUMBER) IS
4487: SELECT txn_relationship_id, object_id, relationship_type_code
4488: FROM csi_t_ii_relationships
4489: WHERE object_id = p_instance_id
4490: AND relationship_type_code = 'COMPONENT-OF'
4491: AND active_end_date IS NULL;
4492:

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

4946: debug('item status is '||l_item_status);
4947:
4948: /* If tranfer component flag is 'Y' then do more checking*/
4949: IF l_transfer_components_flag = 'Y' THEN
4950: /* Check for csi_t_ii_relationships for BOM expl */
4951: l_t_ii_count := 0;
4952: FOR i in check_csi_t_ii_rel(l_new_instance_id)
4953: LOOP
4954: l_t_ii_count := l_t_ii_count + 1;

Line 6204: FROM csi_t_ii_relationships

6200:
6201: CURSOR oe_tld_relns_cur (c_orig_oe_tld IN NUMBER)
6202: IS
6203: SELECT *
6204: FROM csi_t_ii_relationships
6205: WHERE (( subject_type = 'T' AND subject_id = c_orig_oe_tld)
6206: OR ( object_type = 'T' AND object_id = c_orig_oe_tld))
6207: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6208:

Line 6375: FROM csi_t_ii_relationships

6371: IS
6372: CURSOR txn_ii_relns_cur (c_txn_line_detail_id IN NUMBER)
6373: IS
6374: SELECT *
6375: FROM csi_t_ii_relationships
6376: WHERE (( subject_type = 'T' AND subject_id = c_txn_line_detail_id )
6377: OR (object_type = 'T' AND object_id = c_txn_line_detail_id ))
6378: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6379: