APPS.AHL_PC_ASSOCIATION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1018: from mtl_system_items_b

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

Line 1050: from mtl_system_items_b

1046:
1047: CURSOR check_item_valid (p_unit_item_id IN NUMBER)
1048: IS
1049: select 'X'
1050: from mtl_system_items_b
1051: where inventory_item_id = p_unit_item_id and
1052: trunc(sysdate) between nvl(trunc(start_date_active), trunc(sysdate)) and nvl(trunc(end_date_active), trunc(sysdate)) and
1053: inventory_item_status_code not in ('Obsolete','Inactive');
1054: