APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS_V

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 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 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 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 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