eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_POS_NECES_PVT dependencies on CSI_II_RELATIONSHIPS

Line 78: FROM csi_ii_relationships

74: ---
75: --To get extra nodes
76: CURSOR get_extra_nodes_csr(p_csi_item_instance_id IN NUMBER) IS
77: SELECT subject_id
78: FROM csi_ii_relationships
79: WHERE position_reference is null
80: START WITH object_id = p_csi_item_instance_id
81: AND relationship_type_code = 'COMPONENT-OF'
82: AND trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)

Line 92: FROM csi_ii_relationships

88:
89: --To get extra node children nodes
90: CURSOR get_extra_node_child_csr(p_csi_item_instance_id IN NUMBER) IS
91: SELECT subject_id
92: FROM csi_ii_relationships
93: START WITH object_id = p_csi_item_instance_id
94: AND relationship_type_code = 'COMPONENT-OF'
95: AND trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
96: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 113: FROM csi_ii_relationships

109: --
110: --Extra nodes can not be top nodes, so no need to check that.
111: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS
112: SELECT object_id
113: FROM csi_ii_relationships
114: WHERE object_id IN
115: ( SELECT csi_item_instance_id
116: FROM ahl_unit_config_headers
117: WHERE trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)

Line 328: FROM csi_ii_relationships

324: ---
325: --To get extra nodes
326: CURSOR get_extra_nodes_csr(p_csi_item_instance_id IN NUMBER) IS
327: SELECT 'X'
328: FROM csi_ii_relationships
329: WHERE position_reference is null
330: START WITH object_id = p_csi_item_instance_id
331: AND relationship_type_code = 'COMPONENT-OF'
332: AND trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)

Line 477: FROM csi_ii_relationships

473: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
474: SELECT c_csi_instance_id FROM dual
475: UNION ALL
476: SELECT subject_id
477: FROM csi_ii_relationships
478: START WITH object_id = c_csi_instance_id
479: AND relationship_type_code = 'COMPONENT-OF'
480: AND trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
481: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 502: FROM csi_ii_relationships csi

498:
499: --If instance is not uc header, then get it based on instance
500: CURSOR get_pos_ref_reln_csr (c_csi_instance_id IN NUMBER) IS
501: SELECT TO_NUMBER(position_reference)
502: FROM csi_ii_relationships csi
503: WHERE position_reference is not null
504: AND subject_id = c_csi_instance_id
505: AND relationship_type_code = 'COMPONENT-OF'
506: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 521: FROM csi_ii_relationships csi

517: AND trunc(nvl(mc.active_start_date,sysdate)) <= trunc(sysdate)
518: AND trunc(sysdate) < trunc(nvl(mc.active_end_date, sysdate+1))
519: AND NOT EXISTS (
520: SELECT 'X'
521: FROM csi_ii_relationships csi
522: WHERE object_id = c_parent_instance_id
523: AND TO_NUMBER(position_reference) = mc.relationship_id
524: AND relationship_type_code = 'COMPONENT-OF'
525: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 695: FROM csi_ii_relationships

691: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
692: SELECT c_csi_instance_id FROM dual
693: UNION ALL
694: SELECT subject_id
695: FROM csi_ii_relationships
696: START WITH object_id = c_csi_instance_id
697: AND relationship_type_code = 'COMPONENT-OF'
698: AND trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
699: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 719: FROM csi_ii_relationships csi

715:
716: --If instance is not uc header, then get it based on instance
717: CURSOR get_pos_ref_reln_csr (c_csi_instance_id IN NUMBER) IS
718: SELECT TO_NUMBER(position_reference)
719: FROM csi_ii_relationships csi
720: WHERE position_reference is not null
721: AND subject_id = c_csi_instance_id
722: AND relationship_type_code = 'COMPONENT-OF'
723: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 738: FROM csi_ii_relationships csi

734: AND trunc(nvl(mc.active_start_date,sysdate)) <= trunc(sysdate)
735: AND trunc(sysdate) < trunc(nvl(mc.active_end_date, sysdate+1))
736: AND NOT EXISTS (
737: SELECT 'X'
738: FROM csi_ii_relationships csi
739: WHERE object_id = c_parent_instance_id
740: AND TO_NUMBER(position_reference) = mc.relationship_id
741: AND relationship_type_code = 'COMPONENT-OF'
742: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 981: FROM csi_ii_relationships csi_ii

977: WHERE uch.master_config_id = c_mc_header_id
978: AND uch.csi_item_instance_id = c_csi_instance_id
979: UNION ALL
980: SELECT csi_ii.object_id
981: FROM csi_ii_relationships csi_ii
982: WHERE csi_ii.object_id IN
983: (SELECT csi_item_instance_id
984: FROM ahl_unit_config_headers
985: WHERE trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)

Line 1144: FROM csi_ii_relationships

1140: -- Also such instances are inflection points for which get_pos_dtls_csr will not return any records.
1141: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
1142: SELECT c_csi_instance_id FROM dual
1143: WHERE NOT EXISTS (SELECT 1
1144: FROM csi_ii_relationships
1145: WHERE object_id = c_csi_instance_id
1146: AND relationship_type_code = 'COMPONENT-OF'
1147: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1148: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1157: FROM csi_ii_relationships OUTER

1153: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1154: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
1155: UNION ALL
1156: SELECT OUTER.subject_id
1157: FROM csi_ii_relationships OUTER
1158: WHERE NOT EXISTS (SELECT 1
1159: FROM csi_ii_relationships
1160: WHERE object_id = OUTER.subject_id
1161: AND relationship_type_code = 'COMPONENT-OF'

Line 1159: FROM csi_ii_relationships

1155: UNION ALL
1156: SELECT OUTER.subject_id
1157: FROM csi_ii_relationships OUTER
1158: WHERE NOT EXISTS (SELECT 1
1159: FROM csi_ii_relationships
1160: WHERE object_id = OUTER.subject_id
1161: AND relationship_type_code = 'COMPONENT-OF'
1162: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1163: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1184: FROM csi_ii_relationships csi

1180:
1181: -- Get the Relationship of the instance
1182: CURSOR get_pos_ref_reln_csr(c_csi_instance_id IN NUMBER) IS
1183: SELECT TO_NUMBER(position_reference)
1184: FROM csi_ii_relationships csi
1185: WHERE position_reference is not null
1186: AND subject_id = c_csi_instance_id
1187: AND relationship_type_code = 'COMPONENT-OF'
1188: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)

Line 1205: (select object_id from csi_ii_relationships

1201: reln.position_ref_code,
1202: csi.INVENTORY_ITEM_ID,
1203: csi.QUANTITY Inst_qty,
1204: csi.UNIT_OF_MEASURE Inst_uom_code,
1205: (select object_id from csi_ii_relationships
1206: where subject_id = c_instance_id
1207: and relationship_type_code = 'COMPONENT-OF'
1208: and trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1209: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))) parent_instance_id

Line 1479: FROM csi_ii_relationships

1475: -- Also such instances are inflection points for which get_pos_dtls_csr will not return any records.
1476: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
1477: SELECT c_csi_instance_id FROM dual
1478: WHERE NOT EXISTS (SELECT 1
1479: FROM csi_ii_relationships
1480: WHERE object_id = c_csi_instance_id
1481: AND relationship_type_code = 'COMPONENT-OF'
1482: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1483: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1492: FROM csi_ii_relationships OUTER

1488: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1489: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
1490: UNION ALL
1491: SELECT OUTER.subject_id
1492: FROM csi_ii_relationships OUTER
1493: WHERE NOT EXISTS (SELECT 1
1494: FROM csi_ii_relationships
1495: WHERE object_id = OUTER.subject_id
1496: AND relationship_type_code = 'COMPONENT-OF'

Line 1494: FROM csi_ii_relationships

1490: UNION ALL
1491: SELECT OUTER.subject_id
1492: FROM csi_ii_relationships OUTER
1493: WHERE NOT EXISTS (SELECT 1
1494: FROM csi_ii_relationships
1495: WHERE object_id = OUTER.subject_id
1496: AND relationship_type_code = 'COMPONENT-OF'
1497: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1498: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1519: FROM csi_ii_relationships csi

1515:
1516: -- Get the Relationship of the instance
1517: CURSOR get_pos_ref_reln_csr(c_csi_instance_id IN NUMBER) IS
1518: SELECT TO_NUMBER(position_reference)
1519: FROM csi_ii_relationships csi
1520: WHERE position_reference is not null
1521: AND subject_id = c_csi_instance_id
1522: AND relationship_type_code = 'COMPONENT-OF'
1523: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)

Line 1540: (select object_id from csi_ii_relationships

1536: reln.position_ref_code,
1537: csi.INVENTORY_ITEM_ID,
1538: csi.QUANTITY Inst_qty,
1539: csi.UNIT_OF_MEASURE Inst_uom_code,
1540: (select object_id from csi_ii_relationships
1541: where subject_id = c_instance_id
1542: and relationship_type_code = 'COMPONENT-OF'
1543: and trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1544: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))) parent_instance_id