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 2308: ahl_mc_relationships B

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

Line 2332: FROM ahl_mc_relationships

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

Line 2387: ahl_mc_relationships R

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

Line 2404: ahl_mc_relationships m

2400: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
2401: SELECT i.interchange_type_code
2402: FROM csi_item_instances c,
2403: ahl_item_associations_b i,
2404: ahl_mc_relationships m
2405: WHERE m.relationship_id = c_relationship_id
2406: AND c.instance_id = c_instance_id
2407: AND m.item_group_id = i.item_group_id
2408: AND c.inventory_item_id = i.inventory_item_id

Line 3139: FROM ahl_mc_relationships a,

3135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3136: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
3137: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
3138: SELECT f.meaning INTO l_position_ref_meaning
3139: FROM ahl_mc_relationships a,
3140: fnd_lookups f
3141: WHERE a.relationship_id = p_x_uc_instance_rec.relationship_id
3142: AND f.lookup_code (+) = A.position_ref_code
3143: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;

Line 3379: ahl_mc_relationships B

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

Line 3403: FROM ahl_mc_relationships

3399: --c_child_relationshp_id or c_child_relationship_id's own parent as the top node of the sub-config
3400: --can be installed in c_parent_relationship_id
3401: CURSOR check_parent_relationship(c_child_relationship_id NUMBER, c_parent_relationship_id NUMBER) IS
3402: SELECT 1
3403: FROM ahl_mc_relationships
3404: WHERE relationship_id = c_child_relationship_id
3405: AND (parent_relationship_id = c_parent_relationship_id OR
3406: mc_header_id IN (SELECT mc_header_id
3407: FROM ahl_mc_config_relations

Line 3595: ahl_mc_relationships m

3591: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
3592: SELECT i.interchange_type_code
3593: FROM csi_item_instances c,
3594: ahl_item_associations_b i,
3595: ahl_mc_relationships m
3596: WHERE m.relationship_id = c_relationship_id
3597: AND c.instance_id = c_instance_id
3598: AND m.item_group_id = i.item_group_id
3599: AND c.inventory_item_id = i.inventory_item_id

Line 4267: FROM ahl_mc_relationships a,

4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
4265: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
4266: SELECT f.meaning INTO l_position_ref_meaning
4267: FROM ahl_mc_relationships a,
4268: fnd_lookups f
4269: WHERE a.relationship_id = p_relationship_id
4270: AND f.lookup_code (+) = A.position_ref_code
4271: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;

Line 4649: ahl_mc_relationships R,

4645: C.inv_locator_id,
4646: to_number(NULL) uc_header_id
4647: FROM csi_item_instances C,
4648: mtl_system_items_kfv M,
4649: ahl_mc_relationships R,
4650: ahl_item_associations_b A
4651: WHERE C.inventory_item_id = M.inventory_item_id
4652: AND C.inv_master_organization_id = M.organization_id
4653: AND R.item_group_id = A.item_group_id

Line 4797: FROM ahl_mc_relationships MR

4793: -- its not a parent for any other mc position.
4794: --
4795: AND NOT EXISTS (
4796: SELECT 1
4797: FROM ahl_mc_relationships MR
4798: WHERE MR.parent_relationship_id = c_relationship_id
4799: AND trunc(nvl(MR.active_start_date, SYSDATE)) <= trunc(SYSDATE)
4800: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4801: )

Line 4865: ahl_mc_relationships

4861: IS
4862: SELECT
4863: relationship_id
4864: FROM
4865: ahl_mc_relationships
4866: WHERE
4867: relationship_id = p_relationship_id
4868: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
4869: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5393: ahl_mc_relationships R,

5389: C.unit_of_measure uom_code,
5390: to_number(NULL) uc_header_id
5391: FROM csi_item_instances C,
5392: mtl_system_items_kfv M,
5393: ahl_mc_relationships R,
5394: ahl_item_associations_b A
5395: WHERE C.inventory_item_id = M.inventory_item_id
5396: AND C.inv_master_organization_id = M.organization_id
5397: AND R.item_group_id = A.item_group_id

Line 5579: FROM ahl_mc_relationships MR

5575: )
5576: )
5577: AND NOT EXISTS
5578: (SELECT 1
5579: FROM ahl_mc_relationships MR
5580: WHERE MR.parent_relationship_id = c_relationship_id
5581: AND trunc(nvl(MR.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5582: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5583: )

Line 5602: FROM ahl_mc_relationships

5598: ORDER BY 2;
5599:
5600: CURSOR check_relationship_id IS
5601: SELECT relationship_id
5602: FROM ahl_mc_relationships
5603: WHERE relationship_id = p_relationship_id
5604: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
5605: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5606: AND mc_header_id IN (SELECT mc_header_id

Line 5677: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,

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