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 2307: FROM ahl_unit_config_headers A,

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

Line 2377: FROM ahl_unit_config_headers

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

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

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

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

3037: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3039: END IF;
3040:
3041: --Create the sub unit header record in ahl_unit_config_headers
3042: IF l_sub_mc_header_id IS NOT NULL THEN
3043: --Insert the newly added sub unit into UC headers table.
3044: p_x_sub_uc_rec.mc_header_id := l_sub_mc_header_id;
3045: p_x_sub_uc_rec.instance_id := l_new_instance_id;

Line 3165: UPDATE ahl_unit_config_headers

3161: IF (l_root_uc_status_code = 'COMPLETE' AND
3162: x_warning_msg_tbl.count > 0 ) THEN
3163: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
3164: --update is only object_version_number change and not necessary.
3165: UPDATE ahl_unit_config_headers
3166: SET unit_config_status_code = 'INCOMPLETE',
3167: active_uc_status_code = 'UNAPPROVED',
3168: object_version_number = object_version_number + 1,
3169: last_update_date = SYSDATE,

Line 3184: UPDATE ahl_unit_config_headers

3180: (l_root_active_uc_status_code IS NULL OR
3181: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
3182: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
3183: --update is only object_version_number change and not necessary.
3184: UPDATE ahl_unit_config_headers
3185: SET active_uc_status_code = 'UNAPPROVED',
3186: object_version_number = object_version_number + 1,
3187: last_update_date = SYSDATE,
3188: last_updated_by = FND_GLOBAL.user_id,

Line 3206: UPDATE ahl_unit_config_headers

3202: 'l_root_uc_ovn='||l_root_uc_ovn);
3203: END IF;
3204: --IF unit_config_status_code='DRAFT', this update is only object_version_number change and
3205: --not necessary.
3206: UPDATE ahl_unit_config_headers
3207: SET unit_config_status_code = 'DRAFT',
3208: object_version_number = object_version_number + 1,
3209: last_update_date = SYSDATE,
3210: last_updated_by = FND_GLOBAL.user_id,

Line 3223: UPDATE ahl_unit_config_headers

3219: END IF;
3220: ELSIF (p_prod_user_flag = 'Y' AND
3221: x_warning_msg_tbl.count > 0 AND
3222: l_root_uc_status_code = 'COMPLETE') THEN
3223: UPDATE ahl_unit_config_headers
3224: SET unit_config_status_code = 'INCOMPLETE',
3225: object_version_number = object_version_number + 1,
3226: last_update_date = SYSDATE,
3227: last_updated_by = FND_GLOBAL.user_id,

Line 3378: FROM ahl_unit_config_headers A,

3374: A.unit_config_status_code,
3375: A.active_uc_status_code,
3376: A.csi_item_instance_id,
3377: B.relationship_id
3378: FROM ahl_unit_config_headers A,
3379: ahl_mc_relationships B
3380: WHERE A.unit_config_header_id = p_uc_header_id
3381: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
3382: AND A.master_config_id = B.mc_header_id

Line 3433: FROM ahl_unit_config_headers

3429: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3430:
3431: CURSOR get_uc_header(c_instance_id NUMBER) IS
3432: SELECT unit_config_header_id, master_config_id
3433: FROM ahl_unit_config_headers
3434: WHERE csi_item_instance_id = c_instance_id
3435: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3436: --To get all the first level sub-units for a given branch node. First get all of the
3437: --branch node's sub-units and then remove those sub-units which are not first level

Line 3445: FROM ahl_unit_config_headers

3441: /*This query is replaced by the query below it for performance gain.
3442: SELECT subject_id
3443: FROM csi_ii_relationships
3444: WHERE subject_id IN (SELECT csi_item_instance_id
3445: FROM ahl_unit_config_headers
3446: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3447: START WITH object_id = c_instance_id
3448: AND relationship_type_code = 'COMPONENT-OF'
3449: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 3459: FROM ahl_unit_config_headers

3455: MINUS
3456: SELECT subject_id
3457: FROM csi_ii_relationships
3458: WHERE subject_id IN (SELECT csi_item_instance_id
3459: FROM ahl_unit_config_headers
3460: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3461: START WITH object_id IN (SELECT subject_id
3462: FROM csi_ii_relationships
3463: WHERE subject_id IN (SELECT csi_item_instance_id

Line 3464: FROM ahl_unit_config_headers

3460: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3461: START WITH object_id IN (SELECT subject_id
3462: FROM csi_ii_relationships
3463: WHERE subject_id IN (SELECT csi_item_instance_id
3464: FROM ahl_unit_config_headers
3465: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3466: START WITH object_id = c_instance_id
3467: AND relationship_type_code = 'COMPONENT-OF'
3468: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 3485: FROM ahl_unit_config_headers u

3481: */
3482: SELECT i.subject_id
3483: FROM csi_ii_relationships i
3484: WHERE EXISTS (SELECT 'x'
3485: FROM ahl_unit_config_headers u
3486: WHERE u.csi_item_instance_id = i.subject_id
3487: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3488: AND NOT EXISTS (SELECT ci.object_id
3489: FROM csi_ii_relationships ci

Line 3491: FROM ahl_unit_config_headers ui

3487: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
3488: AND NOT EXISTS (SELECT ci.object_id
3489: FROM csi_ii_relationships ci
3490: WHERE (EXISTS (SELECT 'x'
3491: FROM ahl_unit_config_headers ui
3492: WHERE ui.csi_item_instance_id = ci.object_id)
3493: AND ci.object_id <> c_instance_id)
3494: START WITH ci.subject_id = i.subject_id
3495: AND ci.relationship_type_code = 'COMPONENT-OF'

Line 3524: ahl_unit_config_headers U

3520: C.location_type_code,
3521: C.object_version_number,
3522: U.unit_config_header_id uc_header_id
3523: FROM csi_item_instances C,
3524: ahl_unit_config_headers U
3525: WHERE C.instance_id = c_instance_id
3526: AND C.instance_id = U.csi_item_instance_id (+)
3527: --AND U.parent_uc_header_id (+) IS NULL
3528: --Comment out in order to include the extra sibling subunits whose parent_uc_header_id

Line 4179: UPDATE ahl_unit_config_headers

4175: IF l_subunit THEN
4176: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4177: l_parent_uc_header_id,
4178: l_parent_instance_id);
4179: UPDATE ahl_unit_config_headers
4180: --SET parent_uc_header_id = p_uc_header_id
4181: --The parameter p_uc_header_id is not necessarily the parent uc_header_id of the newly
4182: --installed instance.
4183: SET parent_uc_header_id = l_parent_uc_header_id,

Line 4203: UPDATE ahl_unit_config_headers

4199: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4200: l_parent_uc_header_id,
4201: l_parent_instance_id);
4202: FOR l_get_1st_level_subunit IN get_1st_level_subunits(p_instance_id) LOOP
4203: UPDATE ahl_unit_config_headers
4204: SET parent_uc_header_id = l_parent_uc_header_id,
4205: object_version_number = object_version_number + 1,
4206: last_update_date = SYSDATE,
4207: last_updated_by = FND_GLOBAL.user_id,

Line 4290: UPDATE ahl_unit_config_headers

4286: IF p_prod_user_flag = 'N' THEN
4287: IF (l_root_uc_status_code = 'COMPLETE' AND x_warning_msg_tbl.count > 0) THEN
4288: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
4289: --update is only object_version_number change and not necessary.
4290: UPDATE ahl_unit_config_headers
4291: SET unit_config_status_code = 'INCOMPLETE',
4292: active_uc_status_code = 'UNAPPROVED',
4293: object_version_number = object_version_number + 1,
4294: last_update_date = SYSDATE,

Line 4309: UPDATE ahl_unit_config_headers

4305: (l_root_active_uc_status_code IS NULL OR
4306: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
4307: --IF unit_config_status_code='INCOMPLETE' and active_uc_status_code='UNAPPROVED', this
4308: --update is only object_version_number change and not necessary.
4309: UPDATE ahl_unit_config_headers
4310: SET active_uc_status_code = 'UNAPPROVED',
4311: object_version_number = object_version_number + 1,
4312: last_update_date = SYSDATE,
4313: last_updated_by = FND_GLOBAL.user_id,

Line 4331: UPDATE ahl_unit_config_headers

4327: 'l_root_uc_ovn='||l_root_uc_ovn);
4328: END IF;
4329: --IF unit_config_status_code='DRAFT', this update is only object_version_number change and
4330: --not necessary.
4331: UPDATE ahl_unit_config_headers
4332: SET unit_config_status_code = 'DRAFT',
4333: object_version_number = object_version_number + 1,
4334: last_update_date = SYSDATE,
4335: last_updated_by = FND_GLOBAL.user_id,

Line 4348: UPDATE ahl_unit_config_headers

4344: END IF;
4345: ELSIF (p_prod_user_flag = 'Y' AND
4346: x_warning_msg_tbl.count > 0 AND
4347: l_root_uc_status_code = 'COMPLETE') THEN
4348: UPDATE ahl_unit_config_headers
4349: SET unit_config_status_code = 'INCOMPLETE',
4350: object_version_number = object_version_number + 1,
4351: last_update_date = SYSDATE,
4352: last_updated_by = FND_GLOBAL.user_id,

Line 4684: FROM ahl_unit_config_headers H

4680: -- Its not in the top node of any UC.
4681: --
4682: AND NOT EXISTS (
4683: SELECT 1
4684: FROM ahl_unit_config_headers H
4685: WHERE H.csi_item_instance_id = C.instance_id
4686: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4687: )
4688: --

Line 4761: FROM ahl_unit_config_headers_v U,

4757: C.unit_of_measure uom_code,
4758: C.inv_subinventory_name,
4759: C.inv_locator_id,
4760: U.uc_header_id uc_header_id
4761: FROM ahl_unit_config_headers_v U,
4762: csi_item_instances C,
4763: mtl_system_items_kfv M
4764: WHERE U.csi_instance_id = C.instance_id
4765: AND C.inventory_item_id = M.inventory_item_id

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

4877: );
4878: -- Cursor for checking parent instance.
4879: CURSOR check_parent_instance(c_instance_id NUMBER)
4880: IS
4881: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships
4882: --(as the subject_id)
4883: SELECT
4884: 'x'
4885: FROM

Line 4886: ahl_unit_config_headers

4882: --(as the subject_id)
4883: SELECT
4884: 'x'
4885: FROM
4886: ahl_unit_config_headers
4887: WHERE
4888: csi_item_instance_id = c_instance_id
4889: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4890:

Line 4927: FROM ahl_unit_config_headers

4923:
4924: -- Cursor for getting UC status.
4925: CURSOR get_uc_status(c_instance_id NUMBER) IS
4926: SELECT unit_config_status_code
4927: FROM ahl_unit_config_headers
4928: WHERE csi_item_instance_id = c_instance_id
4929: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4930:
4931: CURSOR ahl_instance_details (c_csi_item_instance_id IN NUMBER) IS

Line 4968: ahl_unit_config_headers_v B

4964: B.mc_status,
4965: B.position_ref,
4966: B.root_uc_header_id
4967: FROM ahl_unit_installed_details_v A,
4968: ahl_unit_config_headers_v B
4969: WHERE csi_item_instance_id = c_csi_item_instance_id
4970: AND A.csi_item_instance_id = B.csi_instance_id (+)
4971: AND trunc(nvl(B.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE);
4972: l_instance_details_rec ahl_instance_details%ROWTYPE;

Line 5007: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;

5003: l_priority NUMBER;
5004: i NUMBER;
5005: j NUMBER;
5006: l_dummy_char VARCHAR2(1);
5007: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5008: l_top_instance_id NUMBER;
5009: l_status fnd_lookup_values_vl.meaning%TYPE;
5010: l_msg_count NUMBER;
5011:

Line 5210: FROM ahl_unit_config_headers_v

5206: --its root unit
5207:
5208: IF l_instance_details_rec.root_uc_header_id IS NOT NULL THEN
5209: SELECT uc_status INTO l_status
5210: FROM ahl_unit_config_headers_v
5211: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5212: x_avail_subinv_instance_tbl(j).uc_status := l_status;
5213: ELSE
5214: x_avail_subinv_instance_tbl(j).uc_status := l_instance_details_rec.uc_status;

Line 5356: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;

5352: l_uc_header_id NUMBER;
5353: i NUMBER;
5354: j NUMBER;
5355: l_dummy_char VARCHAR2(1);
5356: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5357: l_top_instance_id NUMBER;
5358: l_status fnd_lookup_values_vl.meaning%TYPE;
5359: l_ignore_quant_vald VARCHAR2(1);
5360:

Line 5467: FROM ahl_unit_config_headers H

5463: --so just include it here.
5464: AND NOT EXISTS
5465: (
5466: SELECT 1
5467: FROM ahl_unit_config_headers H
5468: WHERE H.csi_item_instance_id = C.instance_id
5469: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5470: )
5471: AND upper(M.concatenated_segments) LIKE c_item_number

Line 5501: FROM ahl_unit_config_headers UH, csi_ii_relationships CR

5497: UH.master_config_id mc_header_id,
5498: UH.unit_config_status_code uc_status_code,
5499: UH.active_end_date,
5500: CR.object_id parent_instance_id
5501: FROM ahl_unit_config_headers UH, csi_ii_relationships CR
5502: WHERE UH.csi_item_instance_id = CR.subject_id (+) AND
5503: CR.relationship_type_code (+) = 'COMPONENT-OF' AND
5504: trunc(nvl(CR.active_start_date (+), SYSDATE)) <= trunc(SYSDATE) AND
5505: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)

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

5613: WHERE item_association_id = c_item_association_id;
5614:
5615: -- SATHAPLI Bug# 4912576 fix::SQLid 14402138
5616: -- The cursor definition below is changed so that reference
5617: -- to view ahl_unit_config_headers_v is changed to base tables.
5618: -- Please refer earlier version for previous definition.
5619: CURSOR ahl_instance_details (c_csi_item_instance_id IN NUMBER) IS
5620: select a.csi_item_instance_id,
5621: a.csi_object_version csi_object_version_number,

Line 5667: FROM ahl_unit_config_headers

5663: MCSC.meaning mc_status,
5664: MRSC.meaning position_ref,
5665: (
5666: SELECT unit_config_header_id
5667: FROM ahl_unit_config_headers
5668: WHERE parent_uc_header_id IS NULL
5669: START WITH
5670: unit_config_header_id = U.unit_config_header_id
5671: CONNECT BY

Line 5676: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,

5672: unit_config_header_id = PRIOR parent_uc_header_id
5673: ) root_uc_header_id,
5674: U.csi_item_instance_id csi_instance_id,
5675: U.active_end_date active_end_date
5676: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5677: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5678: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5679: WHERE U.master_config_id = M.mc_header_id AND
5680: M.mc_header_id = R.mc_header_id AND

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

5701: WHERE workorder_id = c_workorder_id;
5702: l_wip_entity_id NUMBER;
5703:
5704: CURSOR check_parent_instance(c_instance_id NUMBER) IS
5705: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships
5706: --(as the subject_id)
5707: SELECT 'x'
5708: FROM ahl_unit_config_headers
5709: WHERE csi_item_instance_id = c_instance_id

Line 5708: FROM ahl_unit_config_headers

5704: CURSOR check_parent_instance(c_instance_id NUMBER) IS
5705: --Parent instance could be either in ahl_unit_config_headers(top node) or in csi_ii_relationships
5706: --(as the subject_id)
5707: SELECT 'x'
5708: FROM ahl_unit_config_headers
5709: WHERE csi_item_instance_id = c_instance_id
5710: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5711: UNION ALL
5712: SELECT 'x'

Line 5760: FROM ahl_unit_config_headers

5756: trunc(nvl(co.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5757:
5758: CURSOR get_uc_status(c_instance_id NUMBER) IS
5759: SELECT unit_config_status_code
5760: FROM ahl_unit_config_headers
5761: WHERE csi_item_instance_id = c_instance_id
5762: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5763:
5764: CURSOR get_csi_ii_relationship_ovn (c_instance_id NUMBER) IS

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

5824: l_wip_entity_id := NULL;
5825: END IF;
5826:
5827: --Validate p_parent_instance_id is Null(for top node) or existing in
5828: --ahl_unit_config_headers or csi_ii_relationships(for non-top node)
5829: IF p_parent_instance_id IS NOT NULL THEN
5830: OPEN check_parent_instance(p_parent_instance_id);
5831: FETCH check_parent_instance INTO l_dummy_char;
5832: IF check_parent_instance%NOTFOUND THEN

Line 5989: FROM ahl_unit_config_headers_v

5985:
5986: -- SATHAPLI::Bug#4912576 fix::SQL ID 14402160 --
5987: /*
5988: SELECT uc_status INTO l_status
5989: FROM ahl_unit_config_headers_v
5990: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5991: */
5992: SELECT FLV.meaning INTO l_status
5993: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

Line 5993: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

5989: FROM ahl_unit_config_headers_v
5990: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5991: */
5992: SELECT FLV.meaning INTO l_status
5993: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV
5994: WHERE AUCH.unit_config_header_id = l_instance_details_rec.root_uc_header_id AND
5995: AUCH.unit_config_status_code = FLV.lookup_code AND
5996: FLV.lookup_type = 'AHL_CONFIG_STATUS' AND
5997: FLV.language = USERENV('LANG');

Line 6108: FROM ahl_unit_config_headers

6104: unit_config_status_code,
6105: active_uc_status_code,
6106: csi_item_instance_id,
6107: parent_uc_header_id
6108: FROM ahl_unit_config_headers
6109: WHERE unit_config_header_id = p_uc_header_id
6110: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6111:
6112: CURSOR csi_item_instance_csr(p_csi_instance_id NUMBER) IS