APPS.AHL_PC_ASSOCIATION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1014: from mtl_system_items_b

1010:
1011: CURSOR check_item_exists (p_unit_item_id IN NUMBER)
1012: IS
1013: select 'X'
1014: from mtl_system_items_b
1015: where inventory_item_id = p_unit_item_id;
1016:
1017: -- Bug 4913773
1018: -- Modified References to Base tables in Cursor get_pc_header_status below

Line 1045: from mtl_system_items_b

1041:
1042: CURSOR check_item_valid (p_unit_item_id IN NUMBER)
1043: IS
1044: select 'X'
1045: from mtl_system_items_b
1046: where inventory_item_id = p_unit_item_id and
1047: trunc(sysdate) between nvl(trunc(start_date_active), trunc(sysdate)) and nvl(trunc(end_date_active), trunc(sysdate)) and
1048: inventory_item_status_code not in ('Obsolete','Inactive');
1049: