APPS.CSD_WIP_JOB_PVT dependencies on MTL_SERIAL_NUMBERS

Line 910: select current_status, current_subinventory_code from mtl_serial_numbers

906: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
907:
908:
909: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is
910: select current_status, current_subinventory_code from mtl_serial_numbers
911: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
912:
913:
914: Cursor c_get_min_operation_seq(p_wip_entity_id number) is