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_INSTANCE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 401: FROM ahl_unit_config_headers

397: object_version_number,
398: unit_config_status_code,
399: active_uc_status_code,
400: csi_item_instance_id
401: FROM ahl_unit_config_headers
402: WHERE unit_config_header_id = p_uc_header_id
403: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
404: l_check_uc_header check_uc_header%ROWTYPE;
405: CURSOR get_uc_descendants(c_instance_id NUMBER) IS

Line 574: UPDATE ahl_unit_config_headers

570: --Not confirmed whether need to copy the record into UC header history table
571: --after status change. Not include the copy right now. (Confirmed and not necessary here)
572: IF p_prod_user_flag = 'N' THEN
573: IF l_root_uc_status_code = 'COMPLETE' THEN
574: UPDATE ahl_unit_config_headers
575: SET unit_config_status_code = 'INCOMPLETE',
576: active_uc_status_code = 'UNAPPROVED',
577: object_version_number = object_version_number + 1,
578: last_update_date = SYSDATE,

Line 591: UPDATE ahl_unit_config_headers

587: END IF;
588: ELSIF (l_root_uc_status_code = 'INCOMPLETE' AND
589: (l_root_active_uc_status_code IS NULL OR
590: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
591: UPDATE ahl_unit_config_headers
592: SET active_uc_status_code = 'UNAPPROVED',
593: object_version_number = object_version_number + 1,
594: last_update_date = SYSDATE,
595: last_updated_by = FND_GLOBAL.user_id,

Line 605: UPDATE ahl_unit_config_headers

601: FND_MSG_PUB.add;
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604: ELSIF l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT') THEN
605: UPDATE ahl_unit_config_headers
606: SET unit_config_status_code = 'DRAFT',
607: object_version_number = object_version_number + 1,
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.user_id,

Line 621: UPDATE ahl_unit_config_headers

617: END IF;
618: END IF;
619: ELSIF p_prod_user_flag = 'Y' THEN
620: IF l_root_uc_status_code = 'COMPLETE' THEN
621: UPDATE ahl_unit_config_headers
622: SET unit_config_status_code = 'INCOMPLETE',
623: object_version_number = object_version_number + 1,
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,

Line 739: FROM ahl_unit_config_headers

735: object_version_number,
736: unit_config_status_code,
737: active_uc_status_code,
738: csi_item_instance_id
739: FROM ahl_unit_config_headers
740: WHERE unit_config_header_id = p_uc_header_id
741: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
742: l_check_uc_header check_uc_header%ROWTYPE;
743:

Line 774: FROM ahl_unit_config_headers

770: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
771:
772: CURSOR check_instance_subunit(c_instance_id NUMBER) IS
773: SELECT unit_config_header_id
774: FROM ahl_unit_config_headers
775: WHERE csi_item_instance_id = c_instance_id
776: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
777:
778: CURSOR get_position_necessity(c_relationship_id NUMBER) IS

Line 792: FROM ahl_unit_config_headers

788: /*This query is replaced by the one below it for performance gain
789: SELECT subject_id
790: FROM csi_ii_relationships
791: WHERE subject_id IN (SELECT csi_item_instance_id
792: FROM ahl_unit_config_headers
793: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
794: START WITH object_id = c_instance_id
795: AND relationship_type_code = 'COMPONENT-OF'
796: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 806: FROM ahl_unit_config_headers

802: MINUS
803: SELECT subject_id
804: FROM csi_ii_relationships
805: WHERE subject_id IN (SELECT csi_item_instance_id
806: FROM ahl_unit_config_headers
807: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
808: START WITH object_id IN (SELECT subject_id
809: FROM csi_ii_relationships
810: WHERE subject_id IN (SELECT csi_item_instance_id

Line 811: FROM ahl_unit_config_headers

807: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
808: START WITH object_id IN (SELECT subject_id
809: FROM csi_ii_relationships
810: WHERE subject_id IN (SELECT csi_item_instance_id
811: FROM ahl_unit_config_headers
812: WHERE trunc(nvl(active_end_date,SYSDATE+1)) > trunc(SYSDATE))
813: START WITH object_id = c_instance_id
814: AND relationship_type_code = 'COMPONENT-OF'
815: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 832: FROM ahl_unit_config_headers u

828: */
829: SELECT i.subject_id
830: FROM csi_ii_relationships i
831: WHERE EXISTS (SELECT 'x'
832: FROM ahl_unit_config_headers u
833: WHERE u.csi_item_instance_id = i.subject_id
834: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
835: AND NOT EXISTS (SELECT ci.object_id
836: FROM csi_ii_relationships ci

Line 838: FROM ahl_unit_config_headers ui

834: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
835: AND NOT EXISTS (SELECT ci.object_id
836: FROM csi_ii_relationships ci
837: WHERE (EXISTS (SELECT 'x'
838: FROM ahl_unit_config_headers ui
839: WHERE ui.csi_item_instance_id = ci.object_id)
840: AND ci.object_id <> c_instance_id)
841: START WITH ci.subject_id = i.subject_id
842: AND ci.relationship_type_code = 'COMPONENT-OF'

Line 861: FROM ahl_unit_config_headers

857: AND trunc(nvl(i.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
858:
859: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
860: SELECT unit_config_header_id
861: FROM ahl_unit_config_headers
862: WHERE csi_item_instance_id = c_instance_id
863: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
864:
865: BEGIN

Line 1073: UPDATE ahl_unit_config_headers

1069: --Here we asume removing the top node instance within its own UC context is not allowed
1070: OPEN check_instance_subunit(p_instance_id);
1071: FETCH check_instance_subunit INTO l_sub_uc_header_id;
1072: IF check_instance_subunit%FOUND THEN --this instance is a sub-unit top node
1073: UPDATE ahl_unit_config_headers
1074: SET parent_uc_header_id = NULL,
1075: unit_config_status_code = l_uc_status_code,
1076: active_uc_status_code = l_active_uc_status_code,
1077: object_version_number = object_version_number + 1,

Line 1106: UPDATE ahl_unit_config_headers

1102: FND_MSG_PUB.add;
1103: END IF;
1104: CLOSE get_uc_header_id;
1105:
1106: UPDATE ahl_unit_config_headers
1107: SET parent_uc_header_id = NULL,
1108: unit_config_status_code = l_uc_status_code,
1109: active_uc_status_code = l_active_uc_status_code,
1110: object_version_number = object_version_number + 1,

Line 1153: UPDATE ahl_unit_config_headers

1149: IF p_prod_user_flag = 'N' THEN
1150: IF (l_root_uc_status_code = 'COMPLETE' AND l_position_necessity = 'MANDATORY') THEN
1151: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
1152: --update is only object_version_number change and not necessary.
1153: UPDATE ahl_unit_config_headers
1154: SET unit_config_status_code = 'INCOMPLETE',
1155: active_uc_status_code = 'UNAPPROVED',
1156: object_version_number = object_version_number + 1,
1157: last_update_date = SYSDATE,

Line 1172: UPDATE ahl_unit_config_headers

1168: (l_root_active_uc_status_code IS NULL OR
1169: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
1170: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
1171: --update is only object_version_number change and not necessary.
1172: UPDATE ahl_unit_config_headers
1173: SET active_uc_status_code = 'UNAPPROVED',
1174: object_version_number = object_version_number + 1,
1175: last_update_date = SYSDATE,
1176: last_updated_by = FND_GLOBAL.user_id,

Line 1188: UPDATE ahl_unit_config_headers

1184: END IF;
1185: ELSIF l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT') THEN
1186: --IF unit_config_status_code='DRAFT', this update is only object_version_number change and
1187: --not necessary.
1188: UPDATE ahl_unit_config_headers
1189: SET unit_config_status_code = 'DRAFT',
1190: object_version_number = object_version_number + 1,
1191: last_update_date = SYSDATE,
1192: last_updated_by = FND_GLOBAL.user_id,

Line 1204: UPDATE ahl_unit_config_headers

1200: END IF;
1201: END IF;
1202: ELSIF p_prod_user_flag = 'Y' THEN
1203: IF (l_root_uc_status_code = 'COMPLETE' AND l_position_necessity = 'MANDATORY') THEN
1204: UPDATE ahl_unit_config_headers
1205: SET unit_config_status_code = 'INCOMPLETE',
1206: object_version_number = object_version_number + 1,
1207: last_update_date = SYSDATE,
1208: last_updated_by = FND_GLOBAL.user_id,

Line 1351: FROM ahl_unit_config_headers

1347: object_version_number,
1348: unit_config_status_code,
1349: active_uc_status_code,
1350: csi_item_instance_id
1351: FROM ahl_unit_config_headers
1352: WHERE unit_config_header_id = p_uc_header_id
1353: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1354: l_check_uc_header check_uc_header%ROWTYPE;
1355: CURSOR get_uc_descendants(c_instance_id NUMBER) IS

Line 2108: UPDATE ahl_unit_config_headers

2104: IF p_prod_user_flag = 'N' THEN
2105: IF l_root_uc_status_code = 'COMPLETE' THEN
2106: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
2107: --update is only object_version_number change and not necessary.
2108: UPDATE ahl_unit_config_headers
2109: SET unit_config_status_code = 'INCOMPLETE',
2110: active_uc_status_code = 'UNAPPROVED',
2111: object_version_number = object_version_number + 1,
2112: last_update_date = SYSDATE,

Line 2125: UPDATE ahl_unit_config_headers

2121: END IF;
2122: ELSIF (l_root_uc_status_code = 'INCOMPLETE' AND
2123: (l_root_active_uc_status_code IS NULL OR
2124: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
2125: UPDATE ahl_unit_config_headers
2126: SET unit_config_status_code = 'INCOMPLETE',
2127: active_uc_status_code = 'UNAPPROVED',
2128: object_version_number = object_version_number + 1,
2129: last_update_date = SYSDATE,

Line 2142: UPDATE ahl_unit_config_headers

2138: END IF;
2139: ELSIF (l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT')) THEN
2140: --IF unit_config_status_code='DRAFT', this update is only object_version_number change and
2141: --not necessary.
2142: UPDATE ahl_unit_config_headers
2143: SET unit_config_status_code = 'DRAFT',
2144: object_version_number = object_version_number + 1,
2145: last_update_date = SYSDATE,
2146: last_updated_by = FND_GLOBAL.user_id,

Line 2308: FROM ahl_unit_config_headers A,

2304: A.unit_config_status_code,
2305: A.active_uc_status_code,
2306: A.csi_item_instance_id,
2307: B.relationship_id
2308: FROM ahl_unit_config_headers A,
2309: ahl_mc_relationships B
2310: WHERE A.unit_config_header_id = p_uc_header_id
2311: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2312: AND A.master_config_id = B.mc_header_id

Line 2378: FROM ahl_unit_config_headers

2374:
2375: --Cursor to check the uniqueness of the sub unit
2376: CURSOR check_uc_name_unique(c_uc_name VARCHAR2) IS
2377: SELECT 'X'
2378: FROM ahl_unit_config_headers
2379: WHERE name = c_uc_name
2380: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2381:
2382: --Cursor to check the validatiy of the mc_header_id (for sub config) according to the mc_name, mc_revision and

Line 3026: --that is not in table csi_ii_realtionships and ahl_unit_config_headers

3022: END IF;
3023:
3024: --Building csi_ii_relationship record should be after create_uc_header because create_uc_header
3025: --will validate the newly created instance, and this validation ensures that the instance is available
3026: --that is not in table csi_ii_realtionships and ahl_unit_config_headers
3027: --Build CSI relationships table
3028: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
3029: l_csi_relationship_rec.object_id := p_parent_instance_id;
3030: l_csi_relationship_rec.position_reference := to_number(p_x_uc_instance_rec.relationship_id);

Line 3047: --Create the sub unit header record in ahl_unit_config_headers

3043: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3045: END IF;
3046:
3047: --Create the sub unit header record in ahl_unit_config_headers
3048: IF l_sub_mc_header_id IS NOT NULL THEN
3049: --Insert the newly added sub unit into UC headers table.
3050: p_x_sub_uc_rec.mc_header_id := l_sub_mc_header_id;
3051: p_x_sub_uc_rec.instance_id := l_new_instance_id;

Line 3173: UPDATE ahl_unit_config_headers

3169: IF (l_root_uc_status_code = 'COMPLETE' AND
3170: x_warning_msg_tbl.count > 0 ) THEN
3171: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
3172: --update is only object_version_number change and not necessary.
3173: UPDATE ahl_unit_config_headers
3174: SET unit_config_status_code = 'INCOMPLETE',
3175: active_uc_status_code = 'UNAPPROVED',
3176: object_version_number = object_version_number + 1,
3177: last_update_date = SYSDATE,

Line 3192: UPDATE ahl_unit_config_headers

3188: (l_root_active_uc_status_code IS NULL OR
3189: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
3190: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
3191: --update is only object_version_number change and not necessary.
3192: UPDATE ahl_unit_config_headers
3193: SET active_uc_status_code = 'UNAPPROVED',
3194: object_version_number = object_version_number + 1,
3195: last_update_date = SYSDATE,
3196: last_updated_by = FND_GLOBAL.user_id,

Line 3214: UPDATE ahl_unit_config_headers

3210: 'l_root_uc_ovn='||l_root_uc_ovn);
3211: END IF;
3212: --IF unit_config_status_code='DRAFT', this update is only object_version_number change and
3213: --not necessary.
3214: UPDATE ahl_unit_config_headers
3215: SET unit_config_status_code = 'DRAFT',
3216: object_version_number = object_version_number + 1,
3217: last_update_date = SYSDATE,
3218: last_updated_by = FND_GLOBAL.user_id,

Line 3231: UPDATE ahl_unit_config_headers

3227: END IF;
3228: ELSIF (p_prod_user_flag = 'Y' AND
3229: x_warning_msg_tbl.count > 0 AND
3230: l_root_uc_status_code = 'COMPLETE') THEN
3231: UPDATE ahl_unit_config_headers
3232: SET unit_config_status_code = 'INCOMPLETE',
3233: object_version_number = object_version_number + 1,
3234: last_update_date = SYSDATE,
3235: last_updated_by = FND_GLOBAL.user_id,

Line 3389: FROM ahl_unit_config_headers A,

3385: A.unit_config_status_code,
3386: A.active_uc_status_code,
3387: A.csi_item_instance_id,
3388: B.relationship_id
3389: FROM ahl_unit_config_headers A,
3390: ahl_mc_relationships B
3391: WHERE A.unit_config_header_id = p_uc_header_id
3392: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
3393: AND A.master_config_id = B.mc_header_id

Line 3444: FROM ahl_unit_config_headers

3440: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3441:
3442: CURSOR get_uc_header(c_instance_id NUMBER) IS
3443: SELECT unit_config_header_id, master_config_id
3444: FROM ahl_unit_config_headers
3445: WHERE csi_item_instance_id = c_instance_id
3446: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3447: --To get all the first level sub-units for a given branch node. First get all of the
3448: --branch node's sub-units and then remove those sub-units which are not first level

Line 3456: FROM ahl_unit_config_headers

3452: /*This query is replaced by the query below it for performance gain.
3453: SELECT subject_id
3454: FROM csi_ii_relationships
3455: WHERE subject_id IN (SELECT csi_item_instance_id
3456: FROM ahl_unit_config_headers
3457: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3458: START WITH object_id = c_instance_id
3459: AND relationship_type_code = 'COMPONENT-OF'
3460: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 3470: FROM ahl_unit_config_headers

3466: MINUS
3467: SELECT subject_id
3468: FROM csi_ii_relationships
3469: WHERE subject_id IN (SELECT csi_item_instance_id
3470: FROM ahl_unit_config_headers
3471: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3472: START WITH object_id IN (SELECT subject_id
3473: FROM csi_ii_relationships
3474: WHERE subject_id IN (SELECT csi_item_instance_id

Line 3475: FROM ahl_unit_config_headers

3471: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3472: START WITH object_id IN (SELECT subject_id
3473: FROM csi_ii_relationships
3474: WHERE subject_id IN (SELECT csi_item_instance_id
3475: FROM ahl_unit_config_headers
3476: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3477: START WITH object_id = c_instance_id
3478: AND relationship_type_code = 'COMPONENT-OF'
3479: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 3496: FROM ahl_unit_config_headers u

3492: */
3493: SELECT i.subject_id
3494: FROM csi_ii_relationships i
3495: WHERE EXISTS (SELECT 'x'
3496: FROM ahl_unit_config_headers u
3497: WHERE u.csi_item_instance_id = i.subject_id
3498: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3499: AND NOT EXISTS (SELECT ci.object_id
3500: FROM csi_ii_relationships ci

Line 3502: FROM ahl_unit_config_headers ui

3498: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3499: AND NOT EXISTS (SELECT ci.object_id
3500: FROM csi_ii_relationships ci
3501: WHERE (EXISTS (SELECT 'x'
3502: FROM ahl_unit_config_headers ui
3503: WHERE ui.csi_item_instance_id = ci.object_id)
3504: AND ci.object_id <> c_instance_id)
3505: START WITH ci.subject_id = i.subject_id
3506: AND ci.relationship_type_code = 'COMPONENT-OF'

Line 3535: ahl_unit_config_headers U

3531: C.location_type_code,
3532: C.object_version_number,
3533: U.unit_config_header_id uc_header_id
3534: FROM csi_item_instances C,
3535: ahl_unit_config_headers U
3536: WHERE C.instance_id = c_instance_id
3537: AND C.instance_id = U.csi_item_instance_id (+)
3538: --AND U.parent_uc_header_id (+) IS NULL
3539: --Comment out in order to include the extra sibling subunits whose parent_uc_header_id

Line 4195: UPDATE ahl_unit_config_headers

4191: IF l_subunit THEN
4192: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4193: l_parent_uc_header_id,
4194: l_parent_instance_id);
4195: UPDATE ahl_unit_config_headers
4196: --SET parent_uc_header_id = p_uc_header_id
4197: --The parameter p_uc_header_id is not necessarily the parent uc_header_id of the newly
4198: --installed instance.
4199: SET parent_uc_header_id = l_parent_uc_header_id,

Line 4219: UPDATE ahl_unit_config_headers

4215: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4216: l_parent_uc_header_id,
4217: l_parent_instance_id);
4218: FOR l_get_1st_level_subunit IN get_1st_level_subunits(p_instance_id) LOOP
4219: UPDATE ahl_unit_config_headers
4220: SET parent_uc_header_id = l_parent_uc_header_id,
4221: object_version_number = object_version_number + 1,
4222: last_update_date = SYSDATE,
4223: last_updated_by = FND_GLOBAL.user_id,

Line 4312: UPDATE ahl_unit_config_headers

4308: IF p_prod_user_flag = 'N' THEN
4309: IF (l_root_uc_status_code = 'COMPLETE' AND x_warning_msg_tbl.count > 0) THEN
4310: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
4311: --update is only object_version_number change and not necessary.
4312: UPDATE ahl_unit_config_headers
4313: SET unit_config_status_code = 'INCOMPLETE',
4314: active_uc_status_code = 'UNAPPROVED',
4315: object_version_number = object_version_number + 1,
4316: last_update_date = SYSDATE,

Line 4331: UPDATE ahl_unit_config_headers

4327: (l_root_active_uc_status_code IS NULL OR
4328: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
4329: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
4330: --update is only object_version_number change and not necessary.
4331: UPDATE ahl_unit_config_headers
4332: SET active_uc_status_code = 'UNAPPROVED',
4333: object_version_number = object_version_number + 1,
4334: last_update_date = SYSDATE,
4335: last_updated_by = FND_GLOBAL.user_id,

Line 4353: UPDATE ahl_unit_config_headers

4349: 'l_root_uc_ovn='||l_root_uc_ovn);
4350: END IF;
4351: --IF unit_config_status_code='DRAFT', this update is only object_version_number change and
4352: --not necessary.
4353: UPDATE ahl_unit_config_headers
4354: SET unit_config_status_code = 'DRAFT',
4355: object_version_number = object_version_number + 1,
4356: last_update_date = SYSDATE,
4357: last_updated_by = FND_GLOBAL.user_id,

Line 4370: UPDATE ahl_unit_config_headers

4366: END IF;
4367: ELSIF (p_prod_user_flag = 'Y' AND
4368: x_warning_msg_tbl.count > 0 AND
4369: l_root_uc_status_code = 'COMPLETE') THEN
4370: UPDATE ahl_unit_config_headers
4371: SET unit_config_status_code = 'INCOMPLETE',
4372: object_version_number = object_version_number + 1,
4373: last_update_date = SYSDATE,
4374: last_updated_by = FND_GLOBAL.user_id,

Line 4706: FROM ahl_unit_config_headers H

4702: -- Its not in the top node of any UC.
4703: --
4704: AND NOT EXISTS (
4705: SELECT 1
4706: FROM ahl_unit_config_headers H
4707: WHERE H.csi_item_instance_id = C.instance_id
4708: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4709: )
4710: --

Line 4784: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base table

4780: UNION ALL
4781: --
4782: -- A position can include alternate subconfigurations.
4783: -- This part of select clause is for picking top node instances of all alternate subconfigs.
4784: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base table
4785: --
4786: SELECT C.instance_id,
4787: C.instance_number,
4788: C.inventory_item_id,

Line 4802: FROM ahl_unit_config_headers

4798: csi_item_instance_id csi_instance_id,
4799: master_config_id mc_header_id,
4800: unit_config_status_code uc_status_code,
4801: active_end_date
4802: FROM ahl_unit_config_headers
4803: -- this sub-unit should not be installed and should have valid status
4804: WHERE parent_uc_header_id IS NULL
4805: AND unit_config_status_code IN ('COMPLETE', 'INCOMPLETE')
4806: )U,

Line 4940: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships

4936: );
4937: -- Cursor for checking parent instance.
4938: CURSOR check_parent_instance(c_instance_id NUMBER)
4939: IS
4940: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships
4941: --(as the subject_id)
4942: SELECT
4943: 'x'
4944: FROM

Line 4945: ahl_unit_config_headers

4941: --(as the subject_id)
4942: SELECT
4943: 'x'
4944: FROM
4945: ahl_unit_config_headers
4946: WHERE
4947: csi_item_instance_id = c_instance_id
4948: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4949:

Line 4986: FROM ahl_unit_config_headers

4982:
4983: -- Cursor for getting UC status.
4984: CURSOR get_uc_status(c_instance_id NUMBER) IS
4985: SELECT unit_config_status_code
4986: FROM ahl_unit_config_headers
4987: WHERE csi_item_instance_id = c_instance_id
4988: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4989:
4990: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base tables

Line 4990: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base tables

4986: FROM ahl_unit_config_headers
4987: WHERE csi_item_instance_id = c_instance_id
4988: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4989:
4990: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base tables
4991: CURSOR ahl_instance_details (c_csi_item_instance_id IN NUMBER) IS
4992: SELECT A.csi_item_instance_id,
4993: A.csi_object_version csi_object_version_number,
4994: A.item_number,

Line 5039: FROM ahl_unit_config_headers

5035: MCSC.meaning mc_status,
5036: MRSC.meaning position_ref,
5037: (
5038: SELECT unit_config_header_id
5039: FROM ahl_unit_config_headers
5040: WHERE parent_uc_header_id IS NULL
5041: START WITH
5042: unit_config_header_id = U.unit_config_header_id
5043: CONNECT BY

Line 5048: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,

5044: unit_config_header_id = PRIOR parent_uc_header_id
5045: ) root_uc_header_id,
5046: U.csi_item_instance_id csi_instance_id,
5047: U.active_end_date active_end_date
5048: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5049: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5050: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5051: WHERE U.master_config_id = M.mc_header_id AND
5052: M.mc_header_id = R.mc_header_id AND

Line 5102: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;

5098: l_priority NUMBER;
5099: i NUMBER;
5100: j NUMBER;
5101: l_dummy_char VARCHAR2(1);
5102: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5103: l_top_instance_id NUMBER;
5104: l_status fnd_lookup_values_vl.meaning%TYPE;
5105: l_msg_count NUMBER;
5106:

Line 5304: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base tables

5300: --Modified on 02/26/2004 in case the status inconsistency occurred between an extra sub-unit and
5301: --its root unit
5302:
5303: IF l_instance_details_rec.root_uc_header_id IS NOT NULL THEN
5304: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base tables
5305: /*
5306: SELECT uc_status INTO l_status
5307: FROM ahl_unit_config_headers_v
5308: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;

Line 5307: FROM ahl_unit_config_headers_v

5303: IF l_instance_details_rec.root_uc_header_id IS NOT NULL THEN
5304: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view AHL_UNIT_CONFIG_HEADERS_V usage to base tables
5305: /*
5306: SELECT uc_status INTO l_status
5307: FROM ahl_unit_config_headers_v
5308: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5309: */
5310: SELECT FLV.meaning INTO l_status
5311: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

Line 5311: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

5307: FROM ahl_unit_config_headers_v
5308: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5309: */
5310: SELECT FLV.meaning INTO l_status
5311: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV
5312: WHERE AUCH.unit_config_header_id = l_instance_details_rec.root_uc_header_id AND
5313: AUCH.unit_config_status_code = FLV.lookup_code AND
5314: FLV.lookup_type = 'AHL_CONFIG_STATUS' AND
5315: FLV.language = USERENV('LANG');

Line 5461: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;

5457: l_uc_header_id NUMBER;
5458: i NUMBER;
5459: j NUMBER;
5460: l_dummy_char VARCHAR2(1);
5461: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5462: l_top_instance_id NUMBER;
5463: l_status fnd_lookup_values_vl.meaning%TYPE;
5464: l_ignore_quant_vald VARCHAR2(1);
5465:

Line 5572: FROM ahl_unit_config_headers H

5568: --so just include it here.
5569: AND NOT EXISTS
5570: (
5571: SELECT 1
5572: FROM ahl_unit_config_headers H
5573: WHERE H.csi_item_instance_id = C.instance_id
5574: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5575: )
5576: AND upper(M.concatenated_segments) LIKE c_item_number

Line 5606: FROM ahl_unit_config_headers UH, csi_ii_relationships CR

5602: UH.master_config_id mc_header_id,
5603: UH.unit_config_status_code uc_status_code,
5604: UH.active_end_date,
5605: CR.object_id parent_instance_id
5606: FROM ahl_unit_config_headers UH, csi_ii_relationships CR
5607: WHERE UH.csi_item_instance_id = CR.subject_id (+) AND
5608: CR.relationship_type_code (+) = 'COMPONENT-OF' AND
5609: trunc(nvl(CR.active_start_date (+), SYSDATE)) <= trunc(SYSDATE) AND
5610: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)

Line 5724: -- to view ahl_unit_config_headers_v is changed to base tables.

5720: WHERE item_association_id = c_item_association_id;
5721:
5722: -- SATHAPLI Bug# 4912576 fix::SQLid 14402138
5723: -- The cursor definition below is changed so that reference
5724: -- to view ahl_unit_config_headers_v is changed to base tables.
5725: -- Please refer earlier version for previous definition.
5726: CURSOR ahl_instance_details (c_csi_item_instance_id IN NUMBER) IS
5727: select a.csi_item_instance_id,
5728: a.csi_object_version csi_object_version_number,

Line 5774: FROM ahl_unit_config_headers

5770: MCSC.meaning mc_status,
5771: MRSC.meaning position_ref,
5772: (
5773: SELECT unit_config_header_id
5774: FROM ahl_unit_config_headers
5775: WHERE parent_uc_header_id IS NULL
5776: START WITH
5777: unit_config_header_id = U.unit_config_header_id
5778: CONNECT BY

Line 5783: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,

5779: unit_config_header_id = PRIOR parent_uc_header_id
5780: ) root_uc_header_id,
5781: U.csi_item_instance_id csi_instance_id,
5782: U.active_end_date active_end_date
5783: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5784: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5785: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5786: WHERE U.master_config_id = M.mc_header_id AND
5787: M.mc_header_id = R.mc_header_id AND

Line 5812: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships

5808: WHERE workorder_id = c_workorder_id;
5809: l_wip_entity_id NUMBER;
5810:
5811: CURSOR check_parent_instance(c_instance_id NUMBER) IS
5812: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships
5813: --(as the subject_id)
5814: SELECT 'x'
5815: FROM ahl_unit_config_headers
5816: WHERE csi_item_instance_id = c_instance_id

Line 5815: FROM ahl_unit_config_headers

5811: CURSOR check_parent_instance(c_instance_id NUMBER) IS
5812: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships
5813: --(as the subject_id)
5814: SELECT 'x'
5815: FROM ahl_unit_config_headers
5816: WHERE csi_item_instance_id = c_instance_id
5817: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5818: UNION ALL
5819: SELECT 'x'

Line 5867: FROM ahl_unit_config_headers

5863: trunc(nvl(co.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5864:
5865: CURSOR get_uc_status(c_instance_id NUMBER) IS
5866: SELECT unit_config_status_code
5867: FROM ahl_unit_config_headers
5868: WHERE csi_item_instance_id = c_instance_id
5869: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5870:
5871: CURSOR get_csi_ii_relationship_ovn (c_instance_id NUMBER) IS

Line 5935: --ahl_unit_config_headers or csi_ii_relationships(for non-top node)

5931: l_wip_entity_id := NULL;
5932: END IF;
5933:
5934: --Validate p_parent_instance_id is Null(for top node) or existing in
5935: --ahl_unit_config_headers or csi_ii_relationships(for non-top node)
5936: IF p_parent_instance_id IS NOT NULL THEN
5937: OPEN check_parent_instance(p_parent_instance_id);
5938: FETCH check_parent_instance INTO l_dummy_char;
5939: IF check_parent_instance%NOTFOUND THEN

Line 6096: FROM ahl_unit_config_headers_v

6092:
6093: -- SATHAPLI::Bug#4912576 fix::SQL ID 14402160 --
6094: /*
6095: SELECT uc_status INTO l_status
6096: FROM ahl_unit_config_headers_v
6097: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
6098: */
6099: SELECT FLV.meaning INTO l_status
6100: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

Line 6100: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

6096: FROM ahl_unit_config_headers_v
6097: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
6098: */
6099: SELECT FLV.meaning INTO l_status
6100: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV
6101: WHERE AUCH.unit_config_header_id = l_instance_details_rec.root_uc_header_id AND
6102: AUCH.unit_config_status_code = FLV.lookup_code AND
6103: FLV.lookup_type = 'AHL_CONFIG_STATUS' AND
6104: FLV.language = USERENV('LANG');

Line 6215: FROM ahl_unit_config_headers

6211: unit_config_status_code,
6212: active_uc_status_code,
6213: csi_item_instance_id,
6214: parent_uc_header_id
6215: FROM ahl_unit_config_headers
6216: WHERE unit_config_header_id = p_uc_header_id
6217: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6218:
6219: CURSOR csi_item_instance_csr(p_csi_instance_id NUMBER) IS

Line 6773: FROM ahl_unit_config_headers AUCH

6769: AND trunc(nvl(CIR.active_end_date, SYSDATE+1)) >trunc(SYSDATE))
6770: )
6771: -- Not a unit configuration
6772: AND (NOT EXISTS (SELECT 1
6773: FROM ahl_unit_config_headers AUCH
6774: WHERE AUCH.csi_item_instance_id = CII.instance_id
6775: AND trunc(nvl(AUCH.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
6776: )
6777: -- Filter by serial number if provided

Line 6807: FROM ahl_unit_config_headers UH, csi_ii_relationships CR

6803: UH.master_config_id mc_header_id,
6804: UH.unit_config_status_code uc_status_code,
6805: UH.active_end_date,
6806: CR.object_id parent_instance_id
6807: FROM ahl_unit_config_headers UH, csi_ii_relationships CR
6808: WHERE UH.csi_item_instance_id = CR.subject_id (+) AND
6809: CR.relationship_type_code (+) = 'COMPONENT-OF' AND
6810: trunc(nvl(CR.active_start_date (+), SYSDATE)) <= trunc(SYSDATE) AND
6811: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)

Line 7138: FROM ahl_unit_config_headers AUCH

7134: AND nvl(AIA.revision, nvl(CII.inventory_revision, -1)) = nvl(CII.inventory_revision, -1)
7135: -- No need to filter out installed instances
7136: -- Not a unit configuration
7137: AND (NOT EXISTS (SELECT 1
7138: FROM ahl_unit_config_headers AUCH
7139: WHERE AUCH.csi_item_instance_id = CII.instance_id
7140: AND trunc(nvl(AUCH.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
7141: )
7142: -- Instance's Item is defined in at least one Inv Org in User's OU

Line 7158: FROM ahl_unit_config_headers UH, csi_ii_relationships CR

7154: UH.master_config_id mc_header_id,
7155: UH.unit_config_status_code uc_status_code,
7156: UH.active_end_date,
7157: CR.object_id parent_instance_id
7158: FROM ahl_unit_config_headers UH, csi_ii_relationships CR
7159: WHERE UH.csi_item_instance_id = CR.subject_id (+) AND
7160: CR.relationship_type_code (+) = 'COMPONENT-OF' AND
7161: trunc(nvl(CR.active_start_date (+), SYSDATE)) <= trunc(SYSDATE) AND
7162: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)