APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_MC_HEADERS_B

Line 2387: FROM ahl_mc_headers_b H,

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

Line 4933: ahl_mc_headers_b

4929: AND mc_header_id IN (
4930: SELECT
4931: mc_header_id
4932: FROM
4933: ahl_mc_headers_b
4934: WHERE
4935: config_status_code = 'COMPLETE'
4936: );
4937: -- Cursor for checking parent instance.

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 5714: FROM ahl_mc_headers_b

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
5714: FROM ahl_mc_headers_b
5715: WHERE config_status_code = 'COMPLETE');
5716:
5717: CURSOR get_priority (c_item_association_id IN NUMBER) IS
5718: SELECT priority

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 6868: FROM ahl_mc_headers_b

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
6868: FROM ahl_mc_headers_b
6869: WHERE config_status_code = 'COMPLETE');
6870:
6871: CURSOR get_asm_req_details_csr IS
6872: SELECT asm.mc_header_id,

Line 7113: FROM ahl_mc_headers_b

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
7113: FROM ahl_mc_headers_b
7114: WHERE config_status_code = 'COMPLETE');
7115:
7116: CURSOR is_instance_valid(c_instance_id IN NUMBER, c_relationship_id IN NUMBER) IS
7117: SELECT CII.inventory_item_id