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_MC_RELATIONSHIPS

Line 780: FROM ahl_mc_relationships

776: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
777:
778: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
779: SELECT position_necessity_code
780: FROM ahl_mc_relationships
781: WHERE relationship_id = c_relationship_id
782: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
783: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
784: --To get all the first level sub-units for a given branch node. First get all of the

Line 2309: ahl_mc_relationships B

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
2313: AND B.parent_relationship_id IS NULL;

Line 2333: FROM ahl_mc_relationships

2329: --c_child_relationshp_id or c_child_relationship_id's own parent as the top node of the sub-config
2330: --can be installed in c_parent_relationship_id
2331: CURSOR check_parent_relationship(c_child_relationship_id NUMBER, c_parent_relationship_id NUMBER) IS
2332: SELECT 'X'
2333: FROM ahl_mc_relationships
2334: WHERE relationship_id = c_child_relationship_id
2335: AND (parent_relationship_id = c_parent_relationship_id OR
2336: mc_header_id IN (SELECT mc_header_id
2337: FROM ahl_mc_config_relations

Line 2388: ahl_mc_relationships R

2384: CURSOR get_sub_mc_header(c_mc_name VARCHAR2, c_mc_revision VARCHAR2, c_relationship_id NUMBER) IS
2385: SELECT H.mc_header_id,
2386: R.relationship_id
2387: FROM ahl_mc_headers_b H,
2388: ahl_mc_relationships R
2389: WHERE H.mc_header_id = R.mc_header_id
2390: AND R.parent_relationship_id IS NULL
2391: AND trunc(nvl(R.active_start_date, SYSDATE)) <= trunc(SYSDATE)
2392: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 2408: ahl_mc_relationships m

2404: itl.interchange_reason
2405: FROM csi_item_instances c,
2406: ahl_item_associations_b i,
2407: ahl_item_associations_tl itl,
2408: ahl_mc_relationships m
2409: WHERE m.relationship_id = c_relationship_id
2410: AND c.instance_id = c_instance_id
2411: AND m.item_group_id = i.item_group_id
2412: AND c.inventory_item_id = i.inventory_item_id

Line 3146: FROM ahl_mc_relationships a,

3142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3143: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
3144: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
3145: SELECT f.meaning INTO l_position_ref_meaning
3146: FROM ahl_mc_relationships a,
3147: fnd_lookups f
3148: WHERE a.relationship_id = p_x_uc_instance_rec.relationship_id
3149: AND f.lookup_code (+) = A.position_ref_code
3150: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;

Line 3390: ahl_mc_relationships B

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
3394: AND B.parent_relationship_id IS NULL;

Line 3414: FROM ahl_mc_relationships

3410: --c_child_relationshp_id or c_child_relationship_id's own parent as the top node of the sub-config
3411: --can be installed in c_parent_relationship_id
3412: CURSOR check_parent_relationship(c_child_relationship_id NUMBER, c_parent_relationship_id NUMBER) IS
3413: SELECT 1
3414: FROM ahl_mc_relationships
3415: WHERE relationship_id = c_child_relationship_id
3416: AND (parent_relationship_id = c_parent_relationship_id OR
3417: mc_header_id IN (SELECT mc_header_id
3418: FROM ahl_mc_config_relations

Line 3609: ahl_mc_relationships m

3605: itl.interchange_reason
3606: FROM csi_item_instances c,
3607: ahl_item_associations_b i,
3608: ahl_item_associations_tl itl,
3609: ahl_mc_relationships m
3610: WHERE m.relationship_id = c_relationship_id
3611: AND c.instance_id = c_instance_id
3612: AND m.item_group_id = i.item_group_id
3613: AND c.inventory_item_id = i.inventory_item_id

Line 4288: FROM ahl_mc_relationships a,

4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
4286: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
4287: SELECT f.meaning INTO l_position_ref_meaning
4288: FROM ahl_mc_relationships a,
4289: fnd_lookups f
4290: WHERE a.relationship_id = p_relationship_id
4291: AND f.lookup_code (+) = A.position_ref_code
4292: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;

Line 4671: ahl_mc_relationships R,

4667: C.inv_locator_id,
4668: to_number(NULL) uc_header_id
4669: FROM csi_item_instances C,
4670: mtl_system_items_kfv M,
4671: ahl_mc_relationships R,
4672: ahl_item_associations_b A
4673: WHERE C.inventory_item_id = M.inventory_item_id
4674: AND C.inv_master_organization_id = M.organization_id
4675: AND R.item_group_id = A.item_group_id

Line 4844: FROM ahl_mc_relationships MR

4840: -- its not a parent for any other mc position.
4841: --
4842: AND NOT EXISTS (
4843: SELECT 1
4844: FROM ahl_mc_relationships MR
4845: WHERE MR.parent_relationship_id = c_relationship_id
4846: AND trunc(nvl(MR.active_start_date, SYSDATE)) <= trunc(SYSDATE)
4847: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4848: )

Line 4924: ahl_mc_relationships

4920: IS
4921: SELECT
4922: relationship_id
4923: FROM
4924: ahl_mc_relationships
4925: WHERE
4926: relationship_id = p_relationship_id
4927: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
4928: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5049: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,

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
5053: R.parent_relationship_id IS NULL AND

Line 5498: ahl_mc_relationships R,

5494: C.unit_of_measure uom_code,
5495: to_number(NULL) uc_header_id
5496: FROM csi_item_instances C,
5497: mtl_system_items_kfv M,
5498: ahl_mc_relationships R,
5499: ahl_item_associations_b A
5500: WHERE C.inventory_item_id = M.inventory_item_id
5501: AND C.inv_master_organization_id = M.organization_id
5502: AND R.item_group_id = A.item_group_id

Line 5686: FROM ahl_mc_relationships MR

5682: )
5683: )
5684: AND NOT EXISTS
5685: (SELECT 1
5686: FROM ahl_mc_relationships MR
5687: WHERE MR.parent_relationship_id = c_relationship_id
5688: AND trunc(nvl(MR.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5689: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5690: )

Line 5709: FROM ahl_mc_relationships

5705: ORDER BY 2;
5706:
5707: CURSOR check_relationship_id IS
5708: SELECT relationship_id
5709: FROM ahl_mc_relationships
5710: WHERE relationship_id = p_relationship_id
5711: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
5712: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5713: AND mc_header_id IN (SELECT mc_header_id

Line 5784: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,

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
5788: R.parent_relationship_id IS NULL AND

Line 6746: ahl_mc_relationships AMR,

6742: to_number(NULL) uc_header_id,
6743: CII.wip_job_id
6744: FROM csi_item_instances CII,
6745: mtl_system_items_kfv MSIK,
6746: ahl_mc_relationships AMR,
6747: ahl_item_associations_b AIA,
6748: hr_all_organization_units_tl HAOUT
6749: WHERE CII.inventory_item_id = NVL(c_inventory_item_id, CII.inventory_item_id)
6750: AND MSIK.inventory_item_id = CII.inventory_item_id

Line 6838: FROM ahl_mc_relationships MR

6834: AND U.parent_instance_id IS NULL -- Exclude installed units
6835: AND U.uc_status_code IN ('COMPLETE', 'INCOMPLETE') -- Exclude DRAFT, APPROVAL_REJECTED
6836: -- Get units only if passed position is a leaf position
6837: AND (NOT EXISTS (SELECT 1
6838: FROM ahl_mc_relationships MR
6839: WHERE MR.parent_relationship_id = c_relationship_id
6840: AND trunc(nvl(MR.active_start_date, SYSDATE)) <= trunc(SYSDATE)
6841: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
6842: )

Line 6863: FROM ahl_mc_relationships

6859: ORDER BY 2; -- Sorted by Instance Number
6860:
6861: CURSOR check_relationship_id(c_relationship_id IN NUMBER) IS
6862: SELECT relationship_id, mc_header_id
6863: FROM ahl_mc_relationships
6864: WHERE relationship_id = c_relationship_id
6865: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
6866: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
6867: AND mc_header_id IN (SELECT mc_header_id

Line 7108: FROM ahl_mc_relationships

7104: RETURN VARCHAR2 IS
7105:
7106: CURSOR check_relationship_id(c_relationship_id IN NUMBER) IS
7107: SELECT relationship_id, mc_header_id
7108: FROM ahl_mc_relationships
7109: WHERE relationship_id = c_relationship_id
7110: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
7111: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
7112: AND mc_header_id IN (SELECT mc_header_id

Line 7120: ahl_mc_relationships AMR,

7116: CURSOR is_instance_valid(c_instance_id IN NUMBER, c_relationship_id IN NUMBER) IS
7117: SELECT CII.inventory_item_id
7118: FROM csi_item_instances CII,
7119: mtl_system_items_kfv MSIK,
7120: ahl_mc_relationships AMR,
7121: ahl_item_associations_b AIA
7122: WHERE CII.instance_id = c_instance_id
7123: AND MSIK.inventory_item_id = CII.inventory_item_id
7124: AND MSIK.organization_id = CII.inv_master_organization_id

Line 7187: FROM ahl_mc_relationships MR

7183: -- Exclude DRAFT, APPROVAL_REJECTED statuses
7184: AND U.uc_status_code IN ('COMPLETE', 'INCOMPLETE')
7185: -- Get units only if passed position is a leaf position
7186: AND (NOT EXISTS (SELECT 1
7187: FROM ahl_mc_relationships MR
7188: WHERE MR.parent_relationship_id = c_relationship_id
7189: AND trunc(nvl(MR.active_start_date, SYSDATE)) <= trunc(SYSDATE)
7190: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
7191: )