DBA Data[Home] [Help]

APPS.AHL_MC_PATH_POSITION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2805: FROM ahl_item_associations_b aia, mtl_system_items_b mtl

2801:
2802: -- for a given item group id, get the serial control code of the associated items
2803: CURSOR get_serial_cntrl_code_csr (p_item_group_id NUMBER) IS
2804: SELECT mtl.serial_number_control_code
2805: FROM ahl_item_associations_b aia, mtl_system_items_b mtl
2806: WHERE aia.item_group_id = p_item_group_id
2807: AND aia.inventory_item_id = mtl.inventory_item_id
2808: AND aia.inventory_org_id = mtl.organization_id
2809: AND aia.interchange_type_code IN ('1-WAY INTERCHANGEABLE', '2-WAY INTERCHANGEABLE')