APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_MC_HEADERS_B

Line 2386: FROM ahl_mc_headers_b H,

2382: --relationship_id (in parent MC)
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)

Line 4874: ahl_mc_headers_b

4870: AND mc_header_id IN (
4871: SELECT
4872: mc_header_id
4873: FROM
4874: ahl_mc_headers_b
4875: WHERE
4876: config_status_code = 'COMPLETE'
4877: );
4878: -- Cursor for checking parent instance.

Line 5607: FROM ahl_mc_headers_b

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
5607: FROM ahl_mc_headers_b
5608: WHERE config_status_code = 'COMPLETE');
5609:
5610: CURSOR get_priority (c_item_association_id IN NUMBER) IS
5611: SELECT priority

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